Change in price relative to baseline date

[jctrue]

Hi everyone - I'm trying to normalize pricing information relative to the date slicer.  Here's what I have:

I'd like to calculate the price at the starting date that I select from the slice, and then determine the $ change in price and the % change in price.

sample PBIX file

I tried this to calculate the Min Date: 

Start Price =

VAR MinDate = CALCULATE(MIN(Sheet2[Price Month]),ALLSELECTED())

return

CALCULATE(SUM(Sheet2[Price]),FILTER(Sheet2,Sheet2[Price Month]=MinDate))

But it only seems to match to date that is the same as the filter.

Thanks in advance!

[jctrue]

Thanks @ribisht17 - that got me closer.. Now I can't figure out how to get the baseline price to match up to the individual products.

I'm sure I need to include "Product Name" somewhere in this expression to calculate the Baseline price, but I can't figure out where to put it.

baseline = CALCULATE(SUM(Sheet2[Price]),FILTER(ALLSELECTED(Sheet2),Sheet2[Price Month]= [mindate]))

Any ideas?

Thanks again!

[ribisht17 · Accepted solution]

I think I got it ,

Min Date = CALCULATE(MIN(Sheet2[Price Month]),FILTER(ALLEXCEPT(Sheet2,Sheet2[Product Name]),Sheet2[Price Month] in FILTERS('Slicer table'[Price Month] )))

baseline = CALCULATE(SUM(Sheet2[Price]),FILTER(ALLEXCEPT(Sheet2,Sheet2[Product Name]),Sheet2[Price Month]=[Min Date]))

Here is my own video on ALLEXCEPT https://youtu.be/fEIaJigVfFg , hope it helps

Regards,

Ritesh

Please mark the answer if it was helpful

[jctrue]

Thank you so much!  This is exactly what I was looking for.

[ribisht17]

@jctrue 

Please check Solved: Keep a Baseline Value from the minimum Date of sel... - Microsoft Power BI Community

Thanks,

Ritesh