Error in visulaization using dateadd measure

[bvsaicharitha]

Hi, I have created a graph using a measure and data add function. When I closed the dashbaord and opened it again, the visulaization is not displaying.

This is the measure I used.

A_Prev Year = CALCULATE([A_Total sales],DATEADD('calendar'[Date],-1,YEAR))

[v-cherch-msft]

Hi @bvsaicharitha

Based on my test, I cannot reproduce the same issue. It seems you may check the relationships between the calendar table and data table. If it is not your case, please share your sample file. You can upload it to OneDrive or Dropbox and post the link here or send me via private message.

Regards,

Cherie

[bvsaicharitha]

Hi

Here is the link

https://www.dropbox.com/s/gl43sn5r2ibe2yd/Dashboard.pbix?dl=0

I have tried using other data also, But still facing the issue with the date add measure in the visualization.

Please check and let me know

[v-cherch-msft · Accepted solution]

Hi @bvsaicharitha

You may try to change the cross filter direction to 'single'.

Regards,

Cherie

[bvsaicharitha]

It worked now. Thank yopu very much

Also, If I want to calculate past 12 months sum from the lastdate of my date month

 CALCULATE([A_TSA],DATEADD('Calendar'[Date],-12,MONTH). This is not giving me correct sales.

Suppose i want to sum from sep-18 to sep 17 and sep- 17 to sep 16 so on, But the measure is calculating from sep- 18 to jan-18