Forum Discussion

Tomast's avatar
Tomast
New Member
3 years ago
Solved

Problem with YDT calculation, values are BLANK after calendar table was updated to include year 2023

Hello,   I updated the calendar table to include 2023 year. Now we are in 27/10/2023, And all the YTD calculations are showing BLANK.    the link in the joins is fine, I tested going back with th...
Need Help
  • Tomast's avatar
    Tomast
    3 years ago

    Hello Comunity!

     

    I've solved the problem, instead of using TotalYTD I've used calculate and filter the current year:

     

    Revenues YTD LT =
    CALCULATE(SUM('Ratios LT '[Revenues]),'Calendario'[Year]=year(today()))
     
    Thanks for all the help!
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Tomast ;

What you mean is to display blank after selecting 2023, and it is normal before selecting 2023; Can you take a screenshot to look at your data (remove sensitive information), from the formula, your dax is correct, since your date in 2023 is indeed updated, but you need to ensure that there is [Revenues IW] in 2023, if this number is not, then naturally it is also null.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.