YTD, QTD, MTD, SAMEPERIODLASTYEAR DAX with Custom Date Calendar

[shafimbd]

Hi all,

I am using a custom date calendar which uses 1st July as start of Financial Year and 30th June as closing of Financial Year. Can anyone help me please with the DAX formulas to calculate the YearToDate (YTD), QuarterToDate (QTD), MonthToDate (MTD), SAMEPERIODLASTYEAR for YEAR, QUARTER & MONTH.

Thanks.

[Interkoubess]

Hi @shafimbd,

For your YTD let's say Revenue, you could use this formula:

Revenue YTD = CALCULATE([Revenue], DATESYTD(Dates[Date],"06-30"))

or

Revenue YTD = CALCULATE([Revenue], DATESYTD(Dates[Date],"06/30"))

Ninter

[shafimbd]

Hi @Interkoubess,

Thank you for your reply. The YTD DAX works fine but I also need the SAMEPERIODLASTYEAR for custom Calendar.

Thanks.

Shahid