Forum Discussion
Calculate Growth Based on Previous Row Calculation
Hi,
PowerBI file attached.
Hope this helps.
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.
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.
Hi,
PowerBI file attached.
Hope this helps.
Amazing...thanks so much. Here I was trying to do some crazy DAX functions and you approached the problem from a completely different perspective. Thanks again for your time!
You are welcome.