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
I need to be help create a Rank column. I need to be able to generate the rank in the context of the Time Period for the Products based on the Amount and This rank will be in the context of the Market where the market acts as a slicer. I added the sample data and the rank. The DAX I created always gives me a rank 1.
Markets | Product | Time Period | Amt | Rank |
North | A | Last 52 Weeks | 1 | 1 |
North | B | Last 52 Weeks | 2 | 2 |
North | C | Last 52 Weeks | 3 | 3 |
North | D | Last 52 Weeks | 4 | 4 |
North | E | Last 52 Weeks | 5 | 5 |
North | F | Last 52 Weeks | 6 | 6 |
North | A | Last 13 Week | 11 | 5 |
North | B | Last 13 Week | 12 | 4 |
North | C | Last 13 Week | 4 | 6 |
North | D | Last 13 Week | 324 | 2 |
North | E | Last 13 Week | 32 | 3 |
North | F | Last 13 Week | 3434 | 1 |
North | A | Last 26 Weeks | 10 | 6 |
North | B | Last 26 Weeks | 34 | 4 |
North | C | Last 26 Weeks | 13 | 5 |
North | D | Last 26 Weeks | 432432 | 1 |
North | E | Last 26 Weeks | 3423 | 2 |
North | F | Last 26 Weeks | 124 | 3 |
North | A | Last 4 Weeks | 1 | 5 |
North | B | Last 4 Weeks | 4 | 2 |
North | C | Last 4 Weeks | 7 | 1 |
North | D | Last 4 Weeks | 2 | 4 |
North | E | Last 4 Weeks | 3 | 3 |
North | F | Last 4 Weeks | 0 | 6 |
Any Help is appreciated.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |