Forum Discussion
Solved
YTD calculation does not work
Hi all, I am calculating YTD value but it does not show up. Please if anyone can help Here is the link to the sample file Test YTD.pbix My actualy file have multiple country, it works for so...
pls try this
Hello ktt777,
In the file it is observed that you have created relationship between Calendar Table Date and Table 2 Account columns. So change that relation to Table 2 Period then you can see the output.
For measure you can create simply like:
CALCULATE(SUM('Table (2)'[ USD ]),DATESYTD('Calendar'[Date]))If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
pls try this