topic Re: filter selection previous month in DAX Commands and Tips

filter selection previous month

Anonymous — Sat, 08 Feb 2020 10:38:09 GMT

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 brand from current month to previous month.

Its like when I select feb and feb rank is greater than jan rank than it should be displaying 1 else 0. It should be dynamic according to the month selction in the filters and if no month filter is there then it should display rank according to sales of current year.

Can anyone please help me out?

Re: filter selection previous month

amitchandak — Sat, 08 Feb 2020 13:30:17 GMT

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