March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Dear all,
I would like to construct a report as below format
my date base is
may i ask you help to know what DAX i can use to get the amounts by different criteres?
I used to use filter to obtain all the information i need and then extract to excel to calculate. but it is not pratical.
Thanks for your help,
Annie
Solved! Go to Solution.
@Orange2045 refer to the post below, it will help you achieve your desired output.
https://community.powerbi.com/t5/Desktop/Create-a-SUM-measure-that-sums-conditionally-based-on-a-val...
Thank you 😀
@Orange2045 refer to the post below, it will help you achieve your desired output.
https://community.powerbi.com/t5/Desktop/Create-a-SUM-measure-that-sums-conditionally-based-on-a-val...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |