Forum Discussion
Solved
conflict with dates and time
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
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)
5 Replies
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)Thank you, It works!! 🙂
