Problem with the DateAdd function

[PradipMCT]

Hi All,

I have written a dateadd() to find the dates for the last month. The formula is:

Dates add = CALCULATE([Total Sales],DATEADD('Date Table'[Date],-1,MONTH))

The problem is it gives few data correct and few incorrect. How do i correct it?

Please see the screenshot:

[Anonymous]

@PradipMCT,

Which table do the first two columns come from? Could you please share sample data of your table for us to analyze?

In my scenario, dateadd function works as expected, and the first two columns come from Date table, you can check the following screenshot.


Regards,
Lydia