Forum Discussion
Solved
Condition between two dates
Hi Everyone, It would be a big help if someone could advise...looking for Employees who have several conditions and one of them is : 1. If 'Passed' from 1 week of enrolled date ...
Hi sraj
You can use the below calculated column:
Column =
VAR _1 = 'tSRAJ'[Pass / Fail] = "Passed"
VAR _2 = 'tSRAJ'[7th day Enrolled] <= 'tSRAJ'[Completed]H
VAR _3 = IF ( AND ( _1 , _2 ) = TRUE() , TRUE() , FALSE() )
RETURN
_3Output is like below:
I used "tSRAJ" as the table name. Apologies! Had did a few solutions in the one PBIX to test syntax! Apologies!
Hope this helps!
Theo 🙂
Great, that worked...Thank you!!