Forum Discussion

ktt777's avatar
ktt777
Helper V
2 years ago
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 some countries, and some don't

Thanks.

Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    2 years ago

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

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    2 years ago

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