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"))
Dangar332's avatar
Dangar332
Resident 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
Power Participant
2 years ago

As I've posted to the other helpers on this issue, the issue is now fixed.

Appreciate your help anyway!