Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've come across an issue where TOTALYTD doesn't work when a Calendar is connected to the Fact Table via Date Key rather than a Date.
I've replicated the issue in an Excel file but the same issue applies in PBI
https://1drv.ms/x/s!Auy_rL3prGGUiT8m1WzkaXvRjxNN
Interestingly if you create an inactive relationship between the actual Date columns in the Calendar and the Fact Table then the YTD issue resolves itself.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.