topic Re: YoY Growth Card in DAX Commands and Tips

YoY Growth Card

JajatiDev — Fri, 02 May 2025 14:50:30 GMT

Hello,
I have created the measure to calculate yoy growth.

VAR _CY = [Total Order Volume] VAR _LY = CALCULATE( [Total Order Volume], DATESBETWEEN( Calendar_Table[Date], EDATE(MIN(Calendar_Table[Date]), -12), EOMONTH(MAX(Consolidated_Order_Book[ReceiveDate]), -12) ) ) VAR _Check = _CY && _LY && HASONEVALUE(Calendar_Table[FY_Year]) VAR _Growth = IF(_Check, DIVIDE(_CY,_LY) -1) RETURN _Growth

The output is giving me the desired result when presented in a graph or table

However, I wish to take this a step forward by presenting the growth rate for the current year in a card dynamically without applying external filters. which I have failed to achieve because the care is returning blank.

Please advise the changes I need to make in the measure to pick the growth rate for FY-25 only.
The financial year in the calculation begins in April and ends in March.

Re: YoY Growth Card

bhanu_gautam — Fri, 02 May 2025 15:17:03 GMT

JajatiDev

If you need to dynamically determine the current financial year based on today's date, you can use the following approach:

DAX
VAR CurrentDate = TODAY()
VAR CurrentFY =
IF(
MONTH(CurrentDate) >= 4,
YEAR(CurrentDate) & "/" & YEAR(CurrentDate) + 1,
YEAR(CurrentDate) - 1 & "/" & YEAR(CurrentDate)
)
VAR PreviousFY =
IF(
MONTH(CurrentDate) >= 4,
YEAR(CurrentDate) - 1 & "/" & YEAR(CurrentDate),
YEAR(CurrentDate) - 2 & "/" & YEAR(CurrentDate) - 1
)
VAR _CY =
CALCULATE(
[Total Order Volume],
FILTER(
Calendar_Table,
Calendar_Table[FY_Year] = CurrentFY
)
)
VAR _LY =
CALCULATE(
[Total Order Volume],
FILTER(
Calendar_Table,
Calendar_Table[FY_Year] = PreviousFY
)
)
VAR _Check = _CY && _LY
VAR _Growth = IF(_Check, DIVIDE(_CY, _LY) - 1)

RETURN
_Growth

Re: YoY Growth Card

JajatiDev — Fri, 02 May 2025 18:09:47 GMT

bhanu_gautam

Thanks!

I tried your measure; however, the output is not as desired.
I need the measure to be dynamic to project the current year growth/decline only. I'm currently achieving the output by applying the year filter to the visual.
I dont want to put any filters. The dax measure should take care of it.

Re: YoY Growth Card

v-dineshya — Mon, 05 May 2025 05:54:24 GMT

Hi JajatiDev ,

Thank you for reaching out to the Microsoft Community Forum.

YOY Growth Measure:

YoY Growth Current FY :=
VAR _MaxFY = MAX(Calendar_Table[FY_Year]) or use MAXX(ALL(Calendar_Table), Calendar_Table[FY_Year])
VAR _CY =
CALCULATE(
[Total Order Volume],
Calendar_Table[FY_Year] = _MaxFY
)
VAR _LY =
CALCULATE(
[Total Order Volume],
Calendar_Table[FY_Year] = _MaxFY - 1
)
VAR _HasData = NOT(ISBLANK(_CY)) && NOT(ISBLANK(_LY))
RETURN
IF(_HasData, DIVIDE(_CY, _LY) - 1)

Please refer below community threads.

Solved: Re: MTD & %YOY in Card Visual - Microsoft Fabric Community

Solved: How to display year-on-year growth rate - Microsoft Fabric Community

Solved: Need to calculate Year-over-Year Growth for "year"... - Microsoft Fabric Community

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

Re: YoY Growth Card

v-dineshya — Thu, 08 May 2025 10:09:08 GMT

Hi JajatiDev ,

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

Re: YoY Growth Card

JajatiDev — Sat, 10 May 2025 18:08:46 GMT

Thank you for all the valuable suggestions.
I was able to work it out.
Included the solution below for everyone's reference.

Also, sharing the screenshot of the card with the final output

YoY_OrderFlow% = VAR _currentDate = TODAY() VAR _currentYear = IF( MONTH(_currentDate) >= 4, YEAR(_currentDate) + 1, YEAR( _currentDate)) VAR _currentFY = "FY-" & _currentYear RETURN CALCULATE( VAR _cy = [TotalOrderedQuantity] VAR _ly_startDate = EDATE( MIN( Calendar_Table[Date]), -12) VAR _ly_endDate = EOMONTH( MAX( OrderData[ReceiveDate] ), -12) VAR _ly = CALCULATE( [TotalOrderedQuantity], DATESBETWEEN( Calendar_Table[Date], _ly_startDate, _ly_endDate ), REMOVEFILTERS( Calendar_Table[FY_Year] ) ) VAR isValidForGrowth = NOT ISBLANK( _cy ) && NOT ISBLANK( _ly ) && _ly <> 0 VAR _growth = IF( isValidForGrowth, DIVIDE( _cy, _ly) - 1) RETURN _growth, FILTER( ALL( Calendar_Table[FY_Year] ), Calendar_Table[FY_Year] = _currentFY ) )