Forum Discussion

John_W's avatar
John_W
Frequent Visitor
2 years ago
Solved

Calculate Growth Based on Previous Row Calculation

Hey All!  Fairly new to Power BI so please forgive any ignorance.   I have the visual below.  I would like to calculate a forecast column based on the Total column and the percent Growth.  Expecati...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi John_W - create the forecast calculated column as below:

replace with your table name

Calculated column:

 

Forecast =
VAR CurrentHourPart = TableName[Hour_Part]
VAR CurrentTotal = TableName[Total]
VAR CurrentGrowth = TableName[Growth]
VAR PreviousHourPart = MAXX(FILTER(TableName, TableName[Hour_Part] = CurrentHourPart - 1), TableName[Forecast])
RETURN
IF(
NOT(ISBLANK(CurrentTotal)),
CurrentTotal,
PreviousHourPart * (1 + CurrentGrowth / 100)
)

 

Ensure that your Hour part column has no gaps

Hope it works, still issue exist share the data in drive, will check it.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

  • John_W's avatar
    John_W
    Frequent Visitor
    2 years ago

    Thanks for looking at it.  Unfortunately, this doesn't work.  

     

    Total and Growth are measures so creating a calculated column is not going to work for me.  (Unless I'm doing something wrong was a probably the case).

    I'll work on getting a sample pbix file uploaded.