Forum Discussion
Solved
TOTALYTD not working
I am using TOTALYTD but no output is coming from it TOTALYTD(COUNT(BookingDataAir[Bookings]),'DimDate'[full_date]) whereas when I use CALCULATE it works fine and gives expected result CALCULATE...
Actually I realized my mistake, my formula was correct but when I was trying to visualize my data I was using date column from my BookingDataAir dataset rather than using them from DimDate dataset and due to that no value was coming for TOTALYTD.
Thanks everyone for help though.
Do you use PBI Desktop as designer ?
If yes, you should know that in PBI Dekstop you can't mark table as date. To use time functions you should define you relationships between factTables/DimDate by using a date or dateime column.
Thus your TOTALYTD will work.