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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you so much! I've been struggling on how to get just the current date with the Now() function and this is basically the only way it works with the end of month DAX functions.