Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.