Conditional Column IF Date.1 1min apart from Date.2 then YES

[NB3]

Hello everyone,

I'm having this issue with one of my datasets. We have applications data with a column Submit Date and a Column Last Activity Date.

What I'd like to do is create a conditional column that show YES is Submit date's time is 1 min apart from Last Activity Date's time.

Submit Date                        Last Activity                  YES/NO

09/29/2020 10:00               09/29/2020 10:01          YES

09/29/2020 11:30               09/29/2020 12:45          NO

Thanks in advance for the help,

Nick

[Fowmy · Accepted solution]

@NB3 

Add this as a column to your table in the model.

Time Over One Min= 
VAR _Time = ABS(DATEDIFF('Table'[Submit Date],'Table'[Last Activity],MINUTE)) RETURN
IF( _Time > 1 , "NO","YES")

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn