Forum Discussion
Pricing Difference
Hi, How do I go about devising a formula to calculate the difference in specific customer product pricing between 2 periods in DAX? Based on the table below, the pricing impact for Product X ...
I am trying to measure the impact of Feb 2021 price for specific product against Jan 2021 prices
Anonymous
And what will you try to measure when more data arrives? Still only hard-coded Jan-Feb prices? Or rather you want this to be a dynamic calculation and you want to really be able to compare any one month to the previous one? Power BI has been designed to be flexible and work for any correct input data, not only for one case.
Jan and Feb is only an example. Preferably when would like to make it more dynamic so that it compares Apr to Mar and May to Apr etc...Current month vs previous month.