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

[v-sihou-msft · Accepted solution]

@Anonymous

To get the number of days in current month, you just need to use ENDOFMONTH() function in your measure.

NumberOfDays in Current Month = DAY(ENDOFMONTH('Table'[Date]))

To calculate days in current year, I don't have easier way than creating a full calendar table for calculation. If you don't want to create a full calendar date table, you can try below "trick":

NumberOfDays in Current Year = IF(MOD(YEAR(MAX('Table'[Date])),4)=0,366,365)

Regards,