Last Year and Year before with 30 June Fiscal Year

[john-paul]

Hi,

I have a Sales data table with 2 previous years and current year to date sales, and a calendar table.

I have calculated current (fiscal year 30 June) YTD sales with:

CALCULATE( [Total Sales], DATESYTD(Calendar_Table[Date], "30/6" ) )

Anyone know how I can also create measures for:

- Last fiscal YTD, and Full Fiscal Year.

- 2 years ago fiscal YTD, and Full Fiscal Year.

I have been trying with DATEADD, SAMEPERIODLASTYEAR, and PARALLELPERIOD but am having trouble with the 30 June Fiscal Year.

Thanks,

John

[amitchandak · Accepted solution]

Hope you are using date calendar

and tried these

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"6/30"))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"6/30"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"6/30"))

Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"6/30"))

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
2 Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-2,Year))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[john-paul]

Thank you amitchandak.

I hadn't even thought of wrapping DATEADD inside DATESYTD.

I really appreciate your help.