Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

filter selection previous month

Hi All,   I have a Sales table having sales brandwise and a date table having month and year columns which are dropped as filters. I have column to display which should be the rank change of that ...
amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

rank diff = if(rank(all(Sales),[MTD Sales],,desc,dense) >rank(all(Sales),[last MTD Sales],,desc,dense),1,0)

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -Decoding Direct Query - Time Intelligence , Winner Coloring on MAP , >HR Analytics , Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin