topic Re: Get the dynamic comparable spend based on common value on selected years in DAX Commands and Tips

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

jovendeluna21 — Fri, 21 Jun 2024 22:42:43 GMT

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:

https://docs.google.com/spreadsheets/d/1gt14nqorF8fKtCMR8xacnDigtAABsOtC/edit?usp=sharing&ouid=116839261107719701663&rtpof=true&sd=true

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

lbendlin — Sat, 22 Jun 2024 15:15:42 GMT

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

jovendeluna21 — Mon, 24 Jun 2024 13:51:07 GMT

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.

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

lbendlin — Mon, 24 Jun 2024 13:43:05 GMT

yes, change the measure to grab the MIN year and then compare to that.

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

jovendeluna21 — Mon, 24 Jun 2024 15:20:36 GMT

Hi, I am aiming to add these three metrics and hopefully you can help me to add