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 last day of the current month?

 

Any help is appreciated. 

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I have a Calendar Table that ranges from 10/15/2018 to 03/28/2019. I wanted to add "Month" as a second column to use as a "Label" for aggregation. I used:

      Month= ENDOFMONTH('Calendar'[Date])

       

      When I pull this on to the visual, it misbehaves. I know this function has a scope of Current Context and that is fine with me in this case. What I don't understand is why Labels are "Offset" by a month?

      I tried to change it from:

      Month= ENDOFMONTH('Calendar'[Date]) to Month= STARTOFMONTH('Calendar'[Date])

      This did fix my Latest month, but it also moved the first month.

      Furthermore, changing TYPE of X-Axis does fix the issue by changing the Label Format; however that's not something I like to have.

      Any expert opinion what's going on here? or is it a known issue or bug? 

  • 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.