cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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 : CALCULATEMAX(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?

1 ACCEPTED SOLUTION
Community Support

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

2 REPLIES 2
Community Support

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

Frequent Visitor

HI , I am looking to get this to happen:

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors