Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |