YTD calculation does not work

[ktt777]

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 some countries, and some don't

Thanks.

[Ahmedx · Accepted solution]

pls try this

[Kishore_KVN · Accepted solution]

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!!

[Ahmedx · Accepted solution]

pls try this