cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bvsaicharitha Regular Visitor
Regular Visitor

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 = CALCULATE([A_Total sales],DATEADD('calendar'[Date],-1,YEAR))Dataadd.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-cherch-msft Super Contributor
Super Contributor

Re: Error in visulaization using dateadd measure

Hi @bvsaicharitha

 

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

 

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
v-cherch-msft Super Contributor
Super Contributor

Re: Error in visulaization using dateadd measure

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bvsaicharitha Regular Visitor
Regular Visitor

Re: Error in visulaization using dateadd measure

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 Super Contributor
Super Contributor

Re: Error in visulaization using dateadd measure

Hi @bvsaicharitha

 

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

 

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bvsaicharitha Regular Visitor
Regular Visitor

Re: Error in visulaization using dateadd measure

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

 

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,219 guests
Please welcome our newest community members: