Forum Discussion
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...
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!
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!