cancel
Showing results for
Did you mean:
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 Month A B C Variance_AC July 1999 1606 -312 Aug 2337 1900 37 Sept 1920 3448 -3706 Oct 1469 1366 -1358 Nov 1523 2162 -3336 Dec 2619 2338 -1261 Jan 1353 1611 -2171 Feb 2226 3770 -1883 Mar 1208 3053 -2281 Apr 1993 1754 -2341 May 1605 1456 -3191 June 1753 2023 -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

## Re: DAX | TimeIntelligence with Fiscal Years.

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.
Moderator

## Re: DAX | TimeIntelligence with Fiscal Years.

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.