Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
10 years ago

EndOfMonth DAX Function Issues

I made a column: ThisDate= TODAY()    I then attempted to make the column: EOM= ENDOFMONTH(Table[ThisDate])   The results return the same date as TODAY().  Why won't it return the date of the las...
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi Bhmiller89,

 

According to your description, you need to get the last day of current month by using a DAX expression, right?

 

If that is the case, you can use the DAX below
LastDay = EOMONTH(today(),0)

 

Regards,

Charlie Liao

edhans's avatar
edhans
Community Champion
9 years ago

ISn't EndOfMonth() then essentially MAX() run on a dates column?