none
Wildcard usage on PowerPivot

    Question

  • Hi,

    How to perform wildcard searches in powerpivot data?

    Can powerpivot handle 80Million rows with each rowsize as 2000bytes ?

    Thanks,
    Raj

    Tuesday, February 14, 2012 8:09 PM

Answers

  • Hi Raj,

    Create a calculated column with this DAX formula:

    In the above Dax formula, replace "DimSalesTerritory[SalesTerritoryCountry]" with your column name. Then all the rows which have "Corp" in the specified column contain 1 as value and all the others have -1. Then just remove all the rows with" -1"  as shown below, So that you only get the rows which have "corp".


    =====================

    Please mark as answer if helpful.

    Thursday, February 16, 2012 5:02 AM

All replies

  • Hi,

    1) For examples on wild card search using DAX in power pivot follow this link

    http://www.powerpivotblog.nl/using-the-excel-function-search-in-powerpivot-dax

    2)Power pivot is an in-memory processing engine. So whatever data you work with should fit in memory. So how much you can handle using power pivot depends on your RAM memory size.

    ==============================

    Please mark as answer if helpful


    • Edited by Dhanumjay K Thursday, February 16, 2012 5:05 AM
    Wednesday, February 15, 2012 5:47 AM
  • Thanks Sachin. Is there a simple way for users to filter a data as "Corp~*" or "Corp*"

    For some reasons, the link suggested and reply on those to use wildcard doesnt work.

    Wednesday, February 15, 2012 4:01 PM
  • Hi Raj,

    Create a calculated column with this DAX formula:

    In the above Dax formula, replace "DimSalesTerritory[SalesTerritoryCountry]" with your column name. Then all the rows which have "Corp" in the specified column contain 1 as value and all the others have -1. Then just remove all the rows with" -1"  as shown below, So that you only get the rows which have "corp".


    =====================

    Please mark as answer if helpful.

    Thursday, February 16, 2012 5:02 AM