Forum Discussion
Calculate Growth Based on Previous Row Calculation
Hi,
PowerBI file attached.
Hope this helps.
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.