Tuesday, February 14, 2012 8:09 PM
How to perform wildcard searches in powerpivot data?
Can powerpivot handle 80Million rows with each rowsize as 2000bytes ?
Wednesday, February 15, 2012 5:47 AM
1) For examples on wild card search using DAX in power pivot follow this link
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
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
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.