Forum Discussion
bvsaicharitha
7 years agoHelper I
Error in visulaization using dateadd measure
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...
- 7 years ago
bvsaicharitha
7 years agoHelper I
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
7 years agoMicrosoft Employee
- bvsaicharitha7 years agoHelper I
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