How to calculate price change using a constant price that changes on slicer date

[TealSA]

Hi! Looking for a solution. Here is the scenario:

1. I have a date slicer, upon selection it gives me the price of my product. 

2. I get the price that is associated with the Min Date on the slicer 

3. I use that price to calculate the price change for all the products with the date.

 something like (Curr Price - Base Price)/ Base Price. 

4. What I am doing is : Get the basedate = CALCULATE( MIN('mytable'[Datecol]),ALLSELECTED('mytable'))

Get the base price : CALCULATE( MAX(MyTable[ProdPrice]), FILTER(MyTable, Mytable[DateCol]    = BaseDt)

But I see Base Price only for BaseDate Month, instead I want to see that constant price for all the months after that BaseDt till 06/2023. But it is blank.  Any help here?

[v-yangliu-msft · Accepted solution]

Hi  @TealSA ,

You can create a calendar table separately and have no relationship to the primary table

Here are the steps you can follow：

1. Create calculated table.

Table2 =
CALENDAR(
    DATE(2023,3,1),DATE(2023,12,31))

2. Create measure.

Want to see this instead =
var _mindate=
MINX(ALLSELECTED('Table2'),[Date1])
return
SUMX(
    FILTER(ALL('Table'),
    'Table'[MyDateField]=_mindate),[Happening])

Difference Column =
MAX('Table'[Happening]) - [Want to see this instead]

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[TealSA]

 HI , I am looking to get this to happen:

Thank you for your help!