Forum Discussion

Tomast's avatar
Tomast
New Member
4 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
    4 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!
Tomast's avatar
Tomast
New Member
4 years ago

I marked my calendar table as date table and also took out the ".date" part of the formula but still appears as blank

  • pbi-novice's avatar
    pbi-novice
    Icon for Helper I rankHelper I
    4 years ago

    Try adding a filter to the TOTALYTD function:

     

     

    Revenues YTD =
    IF(
        ISFILTERED('Calendario'[Date]),
        ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
        TOTALYTD([Revenues IW], 'Calendario'[Date].[Date], YearColumn = YEAR(TODAY))
    )
    • Tomast's avatar
      Tomast
      New Member
      4 years ago

      I've tried that too but is still blank. The only solution I found is to go back and use as last that of the calendar 31/12/2022. Otherwise appear the blank. But I need to add 2023 forecast