Measure for Current Month,Year and Number of days in a month

[Anonymous]

Dear Mates,

I need a measure to calculate the number of days in a month,present month and present year  rather than calculated column.I tried  DAY(LASTDATE('Master Calendar'[Date])) to get number of days but no luck since I need to get the number of days for a particular month irrespective of last date.for eg even though the 'Master Calendar'[Date]) is till 25th of April,I need to show a measure which calculates as 30.Thank you for your time.

Regards

Rishi

[MFelix · Accepted solution]

hi @Anonymous,

You can do something like this and will return the month total days:

NumberDaysMonth = DAY(ENDOFMONTH('Calendar'[Date]))

Regards,

MFelix