Forum Discussion
Solved
Calculating ITD?
Hey everyone, I'm having an issue calculating the ITD value of my dataset. It seems like it should be pretty simple but I can't get it to work properly. Here's what my sample data looks like: ...
Never mind, got it figured out. As counterintuitive as it would seem, I had to remove the relationship between the Data table and the Categories table.
Hopefully this helps someone else in the same boat.
Hi agent,
Try to use the TOTALYTD formula:
Total = TOTALYTD (SUM(Data[Amount]); Datetable[Date])
Regards
MFelix
Try to use the TOTALYTD formula:
Total = TOTALYTD (SUM(Data[Amount]); Datetable[Date])
Regards
MFelix
Thanks MFelix. It still doesn't work once the category breakdown is added. Here's what the TOTALYTD looks like without the category breakdown:
This looks fine - as expected. Once I add the category breakdown, it turns into this:
Any other ideas?
Never mind, got it figured out. As counterintuitive as it would seem, I had to remove the relationship between the Data table and the Categories table.
Hopefully this helps someone else in the same boat.