Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
jovendeluna21
Helper IV
Helper IV

Get the dynamic comparable spend based on common value on selected years

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. 

 

jovendeluna21_0-1719009401005.png

 

I uploaded here the sample data:

https://docs.google.com/spreadsheets/d/1gt14nqorF8fKtCMR8xacnDigtAABsOtC/edit?usp=sharing&ouid=11683...

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

4 REPLIES 4
jovendeluna21
Helper IV
Helper IV

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. 

 

jovendeluna21_0-1719237060364.png

 

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

 

jovendeluna21_0-1719242352392.png

 

jovendeluna21_1-1719242423614.png

 

 

 

lbendlin
Super User
Super User

lbendlin_0-1719069318924.png

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.