DAX | TimeIntelligence with Fiscal Years.

[eswar_chandra]

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

[v-qiuyu-msft · Accepted solution]

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