cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
eswar_chandra Frequent Visitor
Frequent Visitor

DAX | TimeIntelligence with Fiscal Years.

I have a scenario where in I need to calculate the variance of column A, C. The column A has values in Fiscal Year FY20 , column C has values in previous Fiscal Year FY19. Fiscal Year(July through June). Please suggest some DAX formula using which this can be achieved.

 

FY20     
 MonthABCVariance_AC
 July19991606 -312
 Aug23371900 37
 Sept19203448 -3706
 Oct14691366 -1358
 Nov15232162 -3336
 Dec26192338 -1261
 Jan13531611 -2171
 Feb22263770 -1883
 Mar12083053 -2281
 Apr19931754 -2341
 May16051456 -3191
 June17532023 -3638
FY19     
 July  2311 
 Aug  2300 
 Sept  5626 
 Oct  2827 
 Nov  4859 
 Dec  3880 
 Jan  3524 
 Feb  4109 
 Mar  3489 
 Apr  4334 
 May  4796 
 June  5391 
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: DAX | TimeIntelligence with Fiscal Years.

Hi @eswar_chandra

 

You can create a measure below: 

 

Measure = CALCULATE(TOTALMTD(C[C],'Date'[Date]),SAMEPERIODLASTYEAR('Date'[Date])) -A[A]

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: DAX | TimeIntelligence with Fiscal Years.

Hi @eswar_chandra

 

You can create a measure below: 

 

Measure = CALCULATE(TOTALMTD(C[C],'Date'[Date]),SAMEPERIODLASTYEAR('Date'[Date])) -A[A]

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.