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