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 ...
Ahmedx
Super User
Super Userwhat 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.
- Ahmedx
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 - Ahmedx
"E.g. Slicer selection is 2023 and August. Then, it should return July-22 and Aug-22 sum. Hope that makes sense."
it's only two months 😞