Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate Growth Rate

Hi everyone, 

 

It's Ngoc again. I'm new with Power BI so always have stupic questions 😄 Thank you for all your patience and help.

 

I'm calculating % grow rate by month and by year. I saw in other topics that Lookupvalue is used popularly. I tried that and the result is wrong. I don't know what mistakes I did. Below is the formula for Volume Last Year column (the dataraw has so many fields :()

 

Vol LY = LOOKUPVALUE(Rawdata_Month[Volume Act. UC],Rawdata_Month[Customer Type[Customer]]],Rawdata_Month[Customer Type[Customer]]],Rawdata_Month[On/Off Premise],Rawdata_Month[On/Off Premise],Rawdata_Month[Region],Rawdata_Month[Region],Rawdata_Month[Consumer_SKU],Rawdata_Month[Consumer_SKU],Rawdata_Month[Month],Rawdata_Month[Month],Rawdata_Month[Year],Rawdata_Month[Year]-1,0)
 
Then, I created a measure to calculate the % growth
 
% GR vs LY (Vol) = IFERROR(DIVIDE(SUM(Rawdata_Month[Volume Act. UC]),SUM(Rawdata_Month[Vol LY]))-1,0)
 
When I checked in the table, it's right, but when put data into a card, the result is wrong. So can you help to show my mistakes? Thank you in advance.
 
Need Help

1 Reply