Forum Discussion

Antonio_Carneir's avatar
Antonio_Carneir
Frequent Visitor
2 years ago

Prince change history chart

Hey all! I’m currently developing a dashboard in which the user is supposed to be capable of tracking down the price of one or more SKUs over time. For doing this, I was provided with a huge databas...
Antonio_Carneir's avatar
Antonio_Carneir
Frequent Visitor
2 years ago

The purpose of this report is to provide quick and practical general information on the price history of our products and those of our competitors. In some cases, it may be relevant to have a historical curve to make comparisons in the price behavior of certain SKUs, and that’s why I would like to build this chart.

I thought of a logic to try to filter the number of dates, but I don’t have enough knowledge in Power BI to apply it. Maybe you can help me with its development or tell me if it is possible or not.

  1. Create a measure in which it is possible to see the price of one or more selected SKUs on the day before the selected date.
  2. Create another measure that compares the price on day D with the price on day D-1.
  3. Create a measure with the following conditional:
  • If any of the selected SKUs show a variation different from zero (measure 2), the date in question will be kept on the chart. Otherwise, the date will not appear.
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
 it is possible to see the price of one or more selected SKUs on the day before the selected date

This is back to my original question - how many price changes do you expect to happen at most per product per day?  A single change?

 

In general you're on the right track. Change based reports are much better than snapshot based reports (in my opinion)  but they are harder to implement, so you need to be clear in your sample rate requirements before you tackle this.