Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower 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"))
marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
2 years ago

Hey ArchStanton 
You can't compare date with values of type text. In your measure you do that in this part: 

'Cases'[Created On] > "31/03/2020",

You need convert the text into date. Try  'Cases'[Created On] > DATEVALUE("3/31/2020")

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    2 years ago

    I also get this error with your amendment:

     

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

     

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      hi, ArchStanton 

       

      datesytd()  funcyion only give set of group of date not one by one 

      so clarify what you want?

      • ArchStanton's avatar
        ArchStanton
        Icon for Power Participant rankPower Participant
        2 years ago

        I want to add an extra filter to this code, namely = created on> 31 Mar 2020

         

         

        Closed Cases YTD = CALCULATE(
    TOTALYTD(COUNT('Cases'[Case Number]),'Cases'[Resolution Date],"31/03"),
    'Cases'[statecode] = "Resolved")

         

        YTD does not allow me to add additional filters, so i thought DatesYTD would work instead

         

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower 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"))