Forum Discussion
Total Sales by Month Not Calculating Properly after First 2 Months...
Hi RyPCy ,
It sounds like there may be an issue with the data or the DAX formula being used. One possible solution is to check the data for any outliers or errors that may be causing the issue. Additionally, you may want to try using a different DAX formula to calculate the total sales for each month, such as the TOTALYTD function.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi RyPCy ,
It sounds like there may be an issue with the data or the DAX formula being used. One possible solution is to check the data for any outliers or errors that may be causing the issue. Additionally, you may want to try using a different DAX formula to calculate the total sales for each month, such as the TOTALYTD function.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for replying!
It was an error in how the data was being pulled in.
I was able to troubleshoot and fix it 🙂
