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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.