topic Use other columns for row of visual after filter by DATEADD Date columns in CALCULATE in DAX Commands and Tips

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

Anonymous — Mon, 23 Oct 2023 08:36:04 GMT

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!

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

AilleryO — Mon, 23 Oct 2023 08:47:29 GMT

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

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

Anonymous — Mon, 23 Oct 2023 08:53:00 GMT

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