Forum Discussion

bvsaicharitha's avatar
bvsaicharitha
Helper I
7 years ago
Solved

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...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi bvsaicharitha

     

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

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi bvsaicharitha

 

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

 

Regards,

Cherie

bvsaicharitha's avatar
bvsaicharitha
Helper I
7 years ago

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