Forum Discussion
jhauw74
Helper I
Helper ICalculating YoY DAX
Hi Everyone - wishing you all to be well !! I want to know how to calculate YoY based on this scenario: The year on year % needs to be calculated based on: 1. FY 2023 performance which...
Hi Everyone - thanking you all for sharing the ideas on how to solve this issue.
I am managed reconfigure the logic in the DAX by using the following:YoY Growth FY =VAR CurrentWeekEnd = MAX('BOM_DIM_Date'[Week_Ending_Date])VAR CurrentFYStart = DATE(YEAR(CurrentWeekEnd) - IF(MONTH(CurrentWeekEnd) < 7, 1, 0), 7, 1)VAR PreviousFYStart = DATE(YEAR(CurrentFYStart) - 1, 7, 1)VAR CurrentFYValue = CALCULATE([FixedActivationsAll], 'BOM_DIM_Date'[Calendar_Date] >= CurrentFYStart, 'BOM_DIM_Date'[Calendar_Date] <= CurrentWeekEnd)VAR PreviousFYValue = CALCULATE([FixedActivationsAll], 'BOM_DIM_Date'[Calendar_Date] >= PreviousFYStart, 'BOM_DIM_Date'[Calendar_Date] <= EDATE(CurrentWeekEnd, -12))RETURNDIVIDE(CurrentFYValue - PreviousFYValue, PreviousFYValue, 0)
Note:
BOM_DIM_Date - calendar tableFixedActivationsAll - my measure
jhauw74Helper I
Helper IHi Everyone - thanking you all for sharing the ideas on how to solve this issue.
I am managed reconfigure the logic in the DAX by using the following:
YoY Growth FY =
VAR CurrentWeekEnd = MAX('BOM_DIM_Date'[Week_Ending_Date])
VAR CurrentFYStart = DATE(YEAR(CurrentWeekEnd) - IF(MONTH(CurrentWeekEnd) < 7, 1, 0), 7, 1)
VAR PreviousFYStart = DATE(YEAR(CurrentFYStart) - 1, 7, 1)
VAR CurrentFYValue = CALCULATE([FixedActivationsAll], 'BOM_DIM_Date'[Calendar_Date] >= CurrentFYStart, 'BOM_DIM_Date'[Calendar_Date] <= CurrentWeekEnd)
VAR PreviousFYValue = CALCULATE([FixedActivationsAll], 'BOM_DIM_Date'[Calendar_Date] >= PreviousFYStart, 'BOM_DIM_Date'[Calendar_Date] <= EDATE(CurrentWeekEnd, -12))
RETURN
DIVIDE(CurrentFYValue - PreviousFYValue, PreviousFYValue, 0)
Note:
BOM_DIM_Date - calendar table
Note:
BOM_DIM_Date - calendar table
FixedActivationsAll - my measure