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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share the download link of the PBI file.

  • John_W's avatar
    John_W
    Frequent Visitor
    2 years ago

    Link to sample PBIX file 

     

    Looking for a measure that will calculate (1 + Growth) * previous row Acutal.  But then subsequent calculations need to be based upon the same calculation from the previous row.

     

    Thanks for looking.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      You are welcome.  Struggling to understand the data in that file.  What is the purpose of the Base Week Endings slicer?  Can you also share the Excel file with your formulas intact so that i can fortify my understnding.  Not sure of how much i can help but i will try.

      • John_W's avatar
        John_W
        Frequent Visitor
        2 years ago

        Excel File 

         

        Base Week Ending slicer just allows the user to pick particular week ending dates to restrict the Base data that is used.  The [Base] measure calculates the average based on the Week Endings and the day of week from the Current Date that was selected.  For example, if the user selects Current Date of 7/18 (Thu) and Base Week Endings of 7/13 and 7/6, the Base measure will calculate the average of 7/4 and 7/11 - both Thursdays.  In the full version there would be a lot more weeks they could select from.  

         

        I have uploaded the Excel file which has the formulas and quick descriptions. 

         

        Appreciate you and your time!!!  Thanks.