Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago
Solved

DatesYTD Error

Hi,   I want to use DatesYTD instead of Total YTD because DatesYTD accepts more filters. I want to filter on the Created on date being after 31/03/2020   The following code is not working:   C...
Need Help
Show and Tell
  • ArchStanton's avatar
    ArchStanton
    2 years ago

    I've managed to fix it, thanks for your help anyway!

     

    TotalYTD does allow multiple filters contrary to what Ive been told:

     

    Closed Cases YTD2 = CALCULATE(
    TOTALYTD(COUNT('Cases'[Case Number]),'Cases'[Resolution Date],"31/03"),
    'Cases'[statecode] = "Resolved",
    'Cases'[Created On] > DATEVALUE("31/3/2020"))
ChiragGarg2512's avatar
ChiragGarg2512
Solution Sage
2 years ago

ArchStanton , Its comparing the type date with type text which is creating the problem. Instead of "31/03/2020" write Date(2020, 3, 31).

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    2 years ago

    Thanks, I did that, please see the code and I know get a different error (see below code)

     

    Closed Cases YTD2 = CALCULATE(
                        DATESYTD(Date2[Dates],"31-3"),
                        'Cases'[Created On] > DATE(2020,3,31),
                        'Cases'[statecode] = "Resolved")

     

     

    • ChiragGarg2512's avatar
      ChiragGarg2512
      Solution Sage
      2 years ago

      ArchStanton Calculate function returns a single value, so providing it with dates ytd give it multiple values. try using CALCULATETABLE.

      • ArchStanton's avatar
        ArchStanton
        Power Participant
        2 years ago

        I've managed to fix it, thanks for your help anyway!

         

        TotalYTD does allow multiple filters contrary to what Ive been told:

         

        Closed Cases YTD2 = CALCULATE(
    TOTALYTD(COUNT('Cases'[Case Number]),'Cases'[Resolution Date],"31/03"),
    'Cases'[statecode] = "Resolved",
    'Cases'[Created On] > DATEVALUE("31/3/2020"))