DATEADD and SUM returns the same value

[FranckGbadamass]

Hello experts,

I want to retrieve the nb_conv_int for the last month so I used DATEADD as you can see below:

Nb_conv M-1:=CALCULATE([Nb_conv_inter];DATEADD('Date_table'[Date];-1;MONTH))

But I get the same result like this formula:

Nb_conv_inter:=SUM([C.Interactive])

I don't know what's going wrong. Here is my data 

Below my data model:

I appreciate any help thanks.

[v-yetao1-msft]

Hi @FranckGbadamass 

How about the date table ? Can you provide the data of your date table or a pbix file (remove sensitive info) ?

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@FranckGbadamass , Please provide access to file .

But refer to my blog, it should one of the 5 reasons

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

[FranckGbadamass]

It's done sir @amitchandak 

https://docs.google.com/spreadsheets/d/11swUkqj_S_kI37pfFWQppaTAIn9tFF3Y1mYGsBFxAdM/edit?usp=sharing

Thanks for helping.

[amitchandak]

@FranckGbadamass , Data in shared excel is of only 2022. If this does not help
Can you a sample pbix after removing sensitive data.

Make visual /measure and slicer use column from date table. and Date table is marked as date table. This usally cause that issue.