Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Wildcard usage on PowerPivot

Answered Wildcard usage on PowerPivot

  • Tuesday, February 14, 2012 8:09 PM
     
     
    Sign In to Vote
    0

    Hi,

    How to perform wildcard searches in powerpivot data?

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

    Thanks,
    Raj

     

All Replies

  • Wednesday, February 15, 2012 5:47 AM
     
     
    Sign In to Vote
    0

    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 4:01 PM
     
     
    Sign In to Vote
    0

    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.

     
  • Thursday, February 16, 2012 5:02 AM
     
     Answered
    Sign In to Vote
    0

    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.