Use other columns for row of visual after filter by DATEADD Date columns in CALCULATE

[TanFouc87]

Hi guys, I have 2 tables that are Date_ref 

and a table about Sales, in which there are monthly sales value records (I have a column "Parse" which have a start date of each month/ year, I link Sales[Parse] and Date_ref[Date] for relationship between two tables. I would like to compare the Sale of current month and Sale of previous month. Therefore, I have use 2 measures:
CM = Calculate(Sum(Sale[Value]))
PM = Calculate(Sum(Sale[Value]), DATEADD(Date_ref[Date], -1, MONTH))

The output is ok when I set the row of visual is Date_ref[Date]

However, I want to display just three first letters of month. Therefore I create a column in Date_ref which named MonthShort.

But when I use it for row of visual the output is not as expected.

How to solve the problem? Thank you in advance!

[AilleryO · Accepted solution]

Hi,

It seems you're working witha date table but diid you mark this table as a date table ?

(Right click on your date table and choose mark as date table).

To have a date table you can use you need 3 stemps :

1/ create the date table (you did it)

2/ Mark as a date table (i think you did not)

3/ create a relationship with fact table (you did it I think)

Let us kiow if it helps

[TanFouc87]

That's great, It's worked. Thanks a lot.