Solved: Previous Fiscal YTD DAX Not working - Page 2

tstackhouse · ‎01-21-2020

I need to calculate Previous Fiscal Year to date vs Current Fiscal Year to date.

Right now I have Fiscal YTD by:

Fiscal YTD Net Sales = totalytd(sum(VDC_EDW[Net_Sales_Amount]),'Calendar Table'[Date],"3/31")

^ This calculation works correctly

Then I try to get Previous Fiscal Yead to Date with the following:

Fiscal PYTD Net Sales = calculate([Fiscal YTD Net Sales],DATEADD('Calendar Table'[Date],-1,YEAR))

^ This Calculation does not work

Given that today is 1/19/2020.

I am seeing 4/1/2019-1/19/2020 for current Fiscal YTD.(Which is what I need)

I would expect to see 4/1/2018-1/19/2019 for previous fiscal year to date but I am not getting that result.

VasTg · ‎01-21-2020

Please try this..

Fiscal YTD Net Sales = CALCULATE(sum(VDC_EDW[Net_Sales_Amount]),DATESYTD('Calendar Table'[Date],"3/31"))

Then to get Previous Fiscal Yead to Date with the following:

Fiscal PYTD Net Sales = calculate([Fiscal YTD Net Sales],SAMEPERIODLASTYEAR('Calendar Table'[Date]))

If this helps, mark it as a solution.

Kudos are nice too

Connect on LinkedIn

Previous Fiscal YTD DAX Not working