Multiple date comparison Date Slicer

[ErichWong]

I have transactions that have an OPEN DATE and CLOSED Date. The CLOSED date is null for transactions that are still open. I am looking to create a slicer that has a MIN Date and MAX Date that can filter my dataset to show "Active" records. 

Here is my logic. 

If (OpenDate <= MaxDate && ClosedDate is blank)

                Active

Else If (OpenDate <= MaxDate && ClosedDate >= MinDate)

                Active

Else If (ClosedDate < Min Date)

                InActive

Else If (OpenDate > MaxDate)

                InActive

Else

                Inactive

Is something like this possible within PowerBI?

TIA,

Erich Wong

[ErichWong]

Thank you, this is exactly what I needed

[amitchandak · Accepted solution]

@ErichWong , refer my blog on the same topics

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or the attcahed files