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...
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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Hard-coding values into measures is very seldom a good idea. You want to make things responsive and dynamic. If you want to set a specific value for a dimension/measure, please use Filters on the View tab.

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

      I get what you mean now! 

      I will work on this files. Thank you very much!