Condition between two dates

[sraj]

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

I have created a new calculated column to give me the 7th day from the enrolled date which will show me if the user completed it before this date and want only those users who completed it between the 7th day of enrolled date.  

7th Day of Enrolled Date = [Merged] + 7

Now I need to know who are those users who did it...may be another column with Yes or No and filter only those which have 'Yes'?? OR is there anyway I can show which one of them is eligible (7th day of enrolled date is the due date and the complete date should be = or < the Enrolled date)

Can someone please advise on how I can achieve this?

Thank you!

[sraj]

Great, that worked...Thank you!!

[TheoC · Accepted solution]

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

_3

Output 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 🙂