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!
What also worked is to add an slicer with the date and select the current Year
pbi-novice
Helper I
Helper IGive this a shot.
- pbi-novice
**Apply this filter to the visual that uses the TOTALYTD measure.
I tried that too and the card do not show even a blank get crashed