Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

 

This problem is misspecified or underspecified. Saying "between 2 periods" is too general and therefore a formula can't be given. You have to define what exactly you mean by "between 2 periods."

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I am trying to measure the impact of Feb 2021 price for specific product against Jan 2021 prices

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.