Forum Discussion

kristty1805's avatar
kristty1805
Frequent Visitor
5 years ago
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...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    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)

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi kristty1805 ,

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

 

  • kristty1805's avatar
    kristty1805
    Frequent Visitor
    5 years ago

    Thank you, It works!! 🙂

  • kristty1805's avatar
    kristty1805
    Frequent Visitor
    5 years ago

    Hello Payeras_BI ,

     

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