End of month shifted 1 month back in continous chart

[kovacikm78]

Hi guys,

I have problem with EOMonth in my chart of type CONTINOUS. I have it in my calendar table and when used in my chart the name of column is shifted +1 month. eg. my sales are computed for 11/30/2022 and name of the column is December 2022. 
If I change to Categorical, it is ok.

She same is with End of Week.

I have GMT +1 timezone and my calendar is calculated with calendarauto:

"EOMonth", EOMONTH([Date],0),

"EOWeek", [Date]-MOD([Date]-2,7)+6

Your help would be appreciated

[johnt75 · Accepted solution]

Rather than using an end of month column use start of month and start of week. That way the data labels on the chart will correctly line up with the values.