topic Re: How to calculate price change using a constant price that changes on slicer date in DAX Commands and Tips

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

TealSA — Thu, 22 Jun 2023 15:40:18 GMT

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?

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

TealSA — Fri, 23 Jun 2023 17:10:47 GMT

HI , I am looking to get this to happen:

Thank you for your help!

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

Anonymous — Tue, 04 Jul 2023 02:18:29 GMT

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