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 ...
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.you didn't do it right
think again and write logic
you get in a slicer for example 2022.11
convert it to a date then write greater than or equal to this date and at the same time less than or equal to this date