Forum Discussion
Date filter across multiple different date fields
Hi, I have data in a table like below: Unique ID Status 1 Start Date Status 1 End Date Status 2 End Date Status 3 End Date Status 1 Time Status 2 Time Status 3 Time AA 4/29/202...
Hi Anonymous ,
Create an unrelated calendar table as slicer then create measure like this:
Count_1 = CALCULATE(COUNT('Table'[Unique ID]),FILTER('Table','Table'[Status 1 End Date] in VALUES('Table 2'[Date])&&'Table'[Status 1 Start Date]<=MAX('Table 2'[Date])))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
Create an unrelated calendar table as slicer then create measure like this:
Count_1 = CALCULATE(COUNT('Table'[Unique ID]),FILTER('Table','Table'[Status 1 End Date] in VALUES('Table 2'[Date])&&'Table'[Status 1 Start Date]<=MAX('Table 2'[Date])))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you V-lianl-msft this worked for what I was trying to build! 🙂