Forum Discussion
Solved
startofmonth & FirstDate function Issue
Hi All, I was trying to get the first date from a date field or you can say a measure is having a date from which I was trying to get the first date . E.g. the measure is consisting 03-23-2017 , the...
Just to put it briefly
StartofMonth, EndofMonth, FirstDate return the first date/last date in the "Date Column" which they take as argument.
Not the first date/last date of the month
Hi,
I always use the startofmonth with a calculatetable function from my date table using
startofmonth today =
STARTOFMONTH (
CALCULATETABLE (
VALUES ( 'Date'[Date] ),
MONTH ( 'Date'[Date] ) = MONTH ( TODAY () )
)
)
It's easy to use and could also be build with DATEADD() 🙂
Have fun!