Forum Discussion
Totals calculating incorrectly
Hello, I have the following formula which determines whether actuals or forecast should populated the months column. Each individual month column returns correct values but the total column returns ...
Thanks Ahmedx , I tried this using my original data. It returns everything as 0. Would you happen to know the cause for it?
I don't know, maybe it's because of the connection in the model, or the filter action. need to see your file
Thanks Ahmedx, Updated file to show my error: Testing.pbix
what dates do you want to exclude here, I don’t understand something, this measure gives empty
The measure should calculate the year-to-date sum from the selected financial year up to the selected month from that financial year.
E.g. Slicer selection is 2023 and August. Then, it should return July-22 and Aug-22 sum. Hope that makes sense.