Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all
Solved! Go to Solution.
Hi Ana, Interesting use case – you will find 2 solutions here : https://1drv.ms/u/s!Ag8khmd3N7ExgRMLmNkLKGDFmUq1
- DAX : I am using variables and a combination of AddColumns, Values, SumX & Context Transition
- Power Query : I am using a simple Group By in the query editor. This method is pretty simple and works if you can get rid of the « Order ID » column.
Tristan
Hi Ana, Interesting use case – you will find 2 solutions here : https://1drv.ms/u/s!Ag8khmd3N7ExgRMLmNkLKGDFmUq1
- DAX : I am using variables and a combination of AddColumns, Values, SumX & Context Transition
- Power Query : I am using a simple Group By in the query editor. This method is pretty simple and works if you can get rid of the « Order ID » column.
Tristan
Thanks a lot !! It works properly.
Best regards and Merry Christmas !! Happy new year,
Regards from Spain,
Ana
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |