Using 2 selected variables to calculate differences them

[Walden2001]

I have a dataset that contains plant, material, staff and accommodation costs for different cost scenarios.  I want to be able to allow users to be able select one scenario (say Quarter1 High) from a dropdown list and a second scenario (say Q4 Low) from another drop down list. I would then like to able to dymanically calculate the differences in cost for these scenario elements and display the 2 scenario costs and differences in a table. 

I have done it before using min and max Var but I can't here as there is no min and max as I want users to be able to calculate Q4Low minus Q1 High or Q1 High minus Q4 Low depending on what they select first. I'm sure there is a good way to do it but I just can't figure it out at the moment. 

I hope this makes sense, if not then please let me know.

All ideas welcome

Jamie 🙂

[v-lili6-msft · Accepted solution]

hi @Walden2001 

You could get it by this way:

https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

By the way, this blog use two period date slicer to compare, you could just use dropdown list too.

Regards,

Lin

[amitchandak]

@Walden2001, if the are two slicers filtering the same column. You need one from disconnected table. refer this example of date. In place of date you will have qtr

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601