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:
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?