DAX query using AND() and Or() functions

[MBegum]

I'm new to DAX and PowerBi Desktop and am trying to something that is pretty easy in SQL but I'm strugging to replicate it in DAX.

I work for a school and I need to work out the number of students on roll based on start dates and leaving dates, below is some sample data.

StartDate	LeavingDate	Expected Result
01/01/2018		Yes
01/01/2018	01/01/2019	No
01/01/2018		Yes
01/01/2018	01/01/2020	Yes
01/01/2018	01/01/2020	Yes
01/01/2018	01/01/2020	Yes

In SQL I would just do, SELECT * from Table WHERE (StartDate <= GETDATE() and (LeavingDate IS NULL or LeavingDate >= GETDATE()))

I managed to replicate the logic in excel using the formula below but I am struggling to replicate in in DAX/PowerBI Desktop.

 =IF(OR(AND(A2<=TODAY(),B2>=TODAY()), AND(A2<=TODAY(),B2="")),"Yes","no")

Any help would be greatly appreciated. 

[jthomson · Accepted solution]

Something like this as a calculated column maybe?

[MBegum]

Thanks