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 so...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

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

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