How to create a calculation group for YoY calculation( 2 measures without using sameperiodlastyear )

[gvenkatesh_alti]

Hi Community, 

I have 2 measures called TY placed sales and LY placed sales created using base columns TY sales and LY sales. 

I created a measure like below and it is working as expected. 

YoY % (Sales) =

Var a = [TY Placed Sales]

Var b = [LY Placed Sales]

return

IF(ISBLANK(a) || a <=0 || b<=0 , BLANK() , DIVIDE(a-b,b))

However, there are lot of KPIs which requires same Yoy calculations. So , instead of creating a seperate measure , i tried creating a calculation group as shown below. 

YoY % (BOPIS Sales ) =
Var a = [TY Placed Sales]
Var b = [LY Placed Sales]
return
IF(ISBLANK(a) || a <=0 || b<=0 , BLANK() , DIVIDE(a-b,b))

This is not working as expected and not giving any results. 

kindly assist. 

[v-sgandrathi]

Hi @gvenkatesh_alti,

Has your issue been resolved? If the solution provided by the community member effectively addressed your concern, kindly confirm.

We encourage you to mark the response as Accepted Answer and provide Kudos if you found it helpful. This helps us ensure that valuable solutions are shared with the entire community.

Should you have any further questions, please don't hesitate to reach out.

Thank you for your understanding.

[v-sgandrathi]

Hi @gvenkatesh_alti,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @gvenkatesh_alti,

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[rohit1991]

Hi @gvenkatesh_alti ,
You're on the right track by attempting to simplify repeated YoY calculations using a calculation group, but the reason your current approach isn't working is because you're hardcoding specific measures like [TY Placed Sales] and [LY Placed Sales] inside the calculation group logic. 

Calculation groups are designed to be dynamic and work with any measure by leveraging SELECTEDMEASURE(), which represents the measure currently being evaluated in the visual. To achieve the desired YoY % calculation, you should rewrite your calculation group item to use SELECTEDMEASURE() for the current year value, and then calculate the corresponding last year value using filters — for example, by shifting the year or using a "Year Type" column if TY and LY are stored together. This way, your calculation group becomes reusable across all KPIs without needing to reference specific measures, allowing consistent and scalable YoY logic across your report.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar

[Gokul_G16]

Hi @gvenkatesh_alti ,

Please try the following code,

YoY = VAR CurrentYear = YEAR(SELECTEDVALUE('Date'[Date])) VAR PreviousYear = CurrentYear - 1 RETURN CALCULATE( SELECTEDMEASURE(), FILTER( ALL('Date'), 'Date'[Year] = PreviousYear ) )

For YoY%, use this DAX expression: YoY% = VAR CurrentYear = YEAR(SELECTEDVALUE('Date'[Date])) VAR PreviousYear = CurrentYear - 1 VAR CurrentValue = SELECTEDMEASURE() VAR PreviousValue = CALCULATE( SELECTEDMEASURE(), FILTER( ALL('Date'), 'Date'[Year] = PreviousYear ) ) RETURN DIVIDE(CurrentValue - PreviousValue, PreviousValue, 0)

Regards,
Gokul,

If you good with the answer do like me and share your thougths if you not find well...

[Deku · Accepted solution]

You need to pass in the measure to consider using selectedmeasure(), so need something like

Var maxDt = max( date[date] )
Var thisYear= Year( maxDt )
Var a = 
   Calculate(
      Selectedmeasure(),
      Datesbetween( dates[Date], date( thisYear, 1, 1 ), maxDt )
   )
Var b = 
   Calculate(
      Selectedmeasure(),
      DATEADD(Datesbetween( dates[Date], date( thisYear, 1, 1 ), maxDt ), -12, month)
   )
return
IF(ISBLANK(a) || a <=0 || b<=0 , BLANK() , DIVIDE(a-b,b))