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

 

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

  • 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