Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I am stuck with a problem that I'm sure is easy but for the life of me can't figure out how to work it out with DAX. Here's what I need to do:
I appreciate any help you can offer!
CLIENT ID | Revenue Month | Revenue |
128 | Month 1 | 59,218.00 |
419 | Month 1 | 37,661.00 |
419 | Month 2 | 14,906.00 |
742 | Month 1 | 20,597.00 |
742 | Month 2 | 37,679.00 |
742 | Month 3 | 69,221.00 |
1351 | Month 1 | 21,032.00 |
1351 | Month 2 | 21,895.00 |
1351 | Month 3 | 38,689.00 |
1280 | Month 1 | 57,861.00 |
1280 | Month 2 | 37,969.00 |
1280 | Month 3 | 63,414.00 |
1074 | Month 1 | 69,983.00 |
294 | Month 1 | 51,029.00 |
294 | Month 2 | 71,499.00 |
182 | Month 1 | 45,760.00 |
303 | Month 1 | 40,788.00 |
303 | Month 2 | 42,413.00 |
Hi @jzmqt11,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @jzmqt11,
From your description, I could not understand what your desired result, could you want to show a slicer cover the Client ID in multiple months? If so, you could refer to below steps:
Create a new table:
Table = SUMMARIZE('Table1','Table1'[CLIENT ID],"T",CONCATENATEX('Table1','Table1'[Revenue Month],"&"))
Create the relationship and use the [T] coulum as slicer:
Now you could see the result, if I misunderstand you, could you plesase post your desired result if possible, also you could download the pbix file to have a view.
Regards,
Daniel He
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |