Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I just want to request any help on how can I create a report that will show the comparable spend = Site Id & Internal Part Number combination between two selected years.
On below example, the Total USD Spend is the total 2024 spend while the Comparable USD Spend is the comparable spend of 2024 compared to 2023 recurring purchases (Site Id & Internal Part Number combination).
I am aiming to have this kind of report that I just did manually in excel.
I uploaded here the sample data:
Solved! Go to Solution.
Thank you @lbendlin ! Is there a way to make it dynamic? Like let's say on my screenshot, I have 2 year filters and I can compare 2022 to 2024 using the filters.
yes, change the measure to grab the MIN year and then compare to that.
Hi, I am aiming to add these three metrics and hopefully you can help me to add
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |