conflict with dates and time

[kristty1805]

Hello.

Please help me with this. I have several names with different UIDs(Unified Identificator).

The problem is that sometimes the same person have different meetings at the same time. For example: Tomas starts date at 3pm and finish at 4pm but at the same day, starts date at 1pm and finish at 4pm. so he will have a confict of time from 3pm to 4pm. 

How can I make a conditional or using DAX to show that there is a conflict with the time for that person.

I attach a picture so you can see what I mean

[Payeras_BI]

Hi @kristty1805 ,

Compare your code with the one provided. There is an extra "each".

[kristty1805]

Hello @Payeras_BI ,

Just in case, is there any way on using a measure instead of an standard column?

[kristty1805]

Thank you, It works!! 🙂

[Payeras_BI · Accepted solution]

Hi @kristty1805 ,

Add a Custom Column to your table with this code:

= Table.AddColumn(Your_previous_step, "# Overlapping tasks", (x)=> Table.RowCount(Table.SelectRows(Your_previous_step, 
each (_[UID] = x[UID]) and (_[Task] <> x[Task]) and (_[Start]<= x[End]) and (_[End] >= x[Start])))>0)

[kristty1805]

I have this message. Which parameter should I insert? @Payeras_BI