Forum Discussion
Gaps in chart data when calculating cumulative total
Hi Sam_Meyer
Maybe you can try isblank() and if() function, the logical can be like if the target is blank, return the previous cycles value.
Here are links of these two function:
IF function (DAX) - DAX | Microsoft Learn
ISBLANK function (DAX) - DAX | Microsoft Learn
If the above one can't help you, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I have tried to use a cobination of IF and ISBLANK, but the problem is without a data point for a specific Division/Forecast Cycle cross-section it seems as if the ISBLANK has no data point to evaluate. The output is the exact same. This scenario only works if I manually add a missing cross-section which I do not want to do.
As for attaching a simplified pbix - DropBox can't seem to load it after 5 hours of waiting, I can't share files outside my organization in OneDrive, and google drive can't seem to upload it either. Could I possibly email it to you lol.
If not, please check my replies to Ashish - do not want to include here because it is long. Apoligies for formatting I couldn't seem to get it right, but it's pasteable. The only imprtant logic is included in my original post and I am not sure what you mean by special examples.