Forum Discussion
Power ParticipantHelp with Date Filter needed
Hi ArchStanton,
First, create a base measure for Resolved Case Count:Resolved Case Count = CALCULATE( COUNT('Cases'[Case Number]), 'Cases'[statecode] = "Resolved", 'Cases'[Resolution Date] > DATE(2025,3,31) )Then, use TOTALYTD on top of this base measure:
YTD Closed Cases FINAL = TOTALYTD( [Resolved Case Count], ResolutionTable[Date], "31/03" )
Hope this helps !!If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Power ParticipantHi, thanks for your reply. The 'using calendar' measure give me the same duplication as before. Is there a way of writing this measure just using the TOTALYTD function with Year Ending "31/3"?
Also, the ResolutionTable has an active One to Many relationship with the Resolution Date in the Cases Table.
Community SupportHi ArchStanton,
First, create a base measure for Resolved Case Count:
Resolved Case Count =
CALCULATE(
COUNT('Cases'[Case Number]),
'Cases'[statecode] = "Resolved",
'Cases'[Resolution Date] > DATE(2025,3,31)
)
Then, use TOTALYTD on top of this base measure:
YTD Closed Cases FINAL =
TOTALYTD(
[Resolved Case Count],
ResolutionTable[Date],
"31/03"
)
Hope this helps !!
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
- ArchStanton
Thanks for this - much appreciated!