Forum Discussion
Days in Current Month
Hello All, I want to return the number of days in July and I used the measure below measure. It returns 30 days instead of 31 days. Days_In_Current_Month = DAY(ENDOFMONTH('Date'[Date])) ...
If you meant currently selected month then you can use
Days in current month = COUNTROWS ( VALUES ( Dates[Date] ) )or
Days in current month = DISTINCTCOUNT( Dates[Date] )if you meant in July 2020 then
Days in current month = COUNTROWS ( FILTER ( Dates, Dates[Month Number] = MONTH ( TODAY () ) && Dates[Calendar Year Number] = YEAR ( TODAY () ) ) )
AntrikshSharma
Community Champion
Community ChampionIf you meant currently selected month then you can use
Days in current month =
COUNTROWS ( VALUES ( Dates[Date] ) )or
Days in current month = DISTINCTCOUNT( Dates[Date] )if you meant in July 2020 then
Days in current month =
COUNTROWS (
FILTER (
Dates,
Dates[Month Number] = MONTH ( TODAY () )
&& Dates[Calendar Year Number] = YEAR ( TODAY () )
)
)I am looking for a measure that will return the number of days in any current month. July is now the current month so it should return 31 days, Next month is August , when we enter August it shoukd return 31 day as well.
i tried your suggestions, measure number 3 returned blank days. please explain what the year number is suppose to stand for , as i dont have that in my date table.
A snip of my date table below and also the measure below.
thank you
- AntrikshSharmaCalendar year number is just year like 2020, 2019 etc do you have the dates for 2020 in your table?
yes i do.