Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Solved! Go to Solution.
You may try to change the cross filter direction to 'single'.
Regards,
Cherie
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
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
You may try to change the cross filter direction to 'single'.
Regards,
Cherie
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |