Forum Discussion
Using two filters with CALCULATE
I have large spreadsheet with a date in one column, and a string value in another column and I need to produce a table with count of each string value for a given date range. So far I have Table ...
Hi Concat,
Just as what scottsen said, you have to use Measures here not Calculated columns.
By the way, if you want to get the topn records of a table by some conditions such as a specific date as you mentioned, you don't have to use rankx, you can create a table using code below to get top 5 records with filtered date:
Table 2 = TOPN(5, Filter(SheetTable, SheetTable[date] > Date(2016, 7, 1)))
Best Regards
Alex
I would be happy to help if snapshot of the data is provided and your requirements.