DAX retrieve the Month/Quarter etc. from a Custom calendar table based on current date

[sanimesa]

I need to calculate MTD/QTD etc. sales based on a custom calendar. I already got the ranges for the custom calendar. 

My approach to calculate MTD - get the current month from the custom calendar by using a measure. Then sum the sales based on this month. Here is my measure:

(Curr Month Measure) =
VAR current_month_tab = FILTER('Calendar 445', [Date] = TODAY())
return CALCULATE(distinct('Calendar 445'[MonthNameShort]), current_month_tab)

This does seem to work but not sure the most efficient, Comments appreciated. 

[WolfBiber]

Hey,

check out TOTALMTD and TOTALQTD 

Greetings,

Wolf

[sanimesa]

@WolfBiber Does the TotalMTD etc function work for custom calendar? For instance, Nov 2017 actually ranges from Oct 28- Nov 25 in the current year. I need the sum of sales for the period, not sure how it will work out.