Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Price Index

Hi there,    we would love to have price indices in power bi - has anybody tried that before and could share best practices?  we have three tables   Price History date - sku - price  has an e...
mailfalanyok's avatar
mailfalanyok
Frequent Visitor
6 years ago

Anyone able to find a solution to this? 

 

Problem is; food prices like cherry only have at summer times and when we go winter price index fells like truck but it should not. Because it has to not count cheery anymore in the basket

 

June Lemon 5

June Chery 7

June Bread 2

June Total_Basket is 14  (food price index here is 100)

 

July Lemon 6

July Chery 8

July Bread 2

July Total_Basket is 16   (so food price index icreased %14 to 114)

 

Agu Lemon 3

Agu Chery 4

Agu Bread 2

Agu Total_Basket is 9   (so food price index decreased -%35 to 65)

 

No more cherry price in sept.

 

Sep Lemon 3

Sep Bread 2

Sep Total_Basket is 5   (so food price index have not changed. both lemon and bread is 2 so result should be %0 change with 65)

But dax calculates this as -%64 change to 36)

 

So we need a dynamix basket total calculator and add products like cheery to if it has both at start and end of calculation dates else should ignore that value from both start and end.

Thanks everyone.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The "basket price indexes" solution can be found in the attached file. It works exactly as you wanted. Please inspect the solution thoroughly.

     

    Best

    D

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      By the way, in order to get the price indexes, you have to click on any of the rows in the Base Basket table.

      If you want to see the percentage difference (instead of the value of the index), you have to modify the measure a bit. Just subtract its value from 100% (which means 1).

      Best
      D
      • mailfalanyok's avatar
        mailfalanyok
        Frequent Visitor
        6 years ago

        Thank you very much darlove.

        Can we may be make it hard coded to "January 2020 or first month items's price appears" to 100 so that we dont need to click a month year to see index? 

        By this way I can achieve

        yearly index,

        -12 month index

        5 year index

         

        etc.

         

        Thanks a bunch!