Forum Discussion

hholtshopple's avatar
hholtshopple
Frequent Visitor
8 years ago
Solved

Indexed growth Rate

Hello!   This is my first post, just learning how to use PowerBi as I go!   I am trying to index a growth rate to the first year in my data set(2014) . Data set is revenue by year, region, produc...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Try this for your 2014Rev measure:

     

    2014Rev = sumX(FILTER(ALL(FullyMappedData),FullyMappedData[Year]=2014),FullyMappedData[Revenue (USD)])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Try this for your 2014Rev measure:

 

2014Rev = sumX(FILTER(ALL(FullyMappedData),FullyMappedData[Year]=2014),FullyMappedData[Revenue (USD)])
hholtshopple's avatar
hholtshopple
Frequent Visitor
8 years ago

Greg, 

 

I was able to see my error. I ended up pulling the year2 out of the columun and could easily display Indexed Growth rate. 

 

I truly appreciate your help!