Forum Discussion
Solved
Multiple overlapping dates and grouping data based on a flow - Urgent
Hello, Need urgent help. I am working on the below data with requirements below. Anonymous Pragati @Greg_Deckler Requierement1 - Need to group the cases were the flow of state is from non zero t...
Hi Vivek2456 ,
check if my solution is ok for you.
https://1drv.ms/u/s!Aj45jbu0mDVJi21V7mLokpYI0B9m?e=bZisFN
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you. Apologies but the dara is confidential to share. If possible could you look at the last requirement alone and help me with the solution. So the data I get in power query will be like the table below and I am looking to identify the cases that overlap mutually.
Hi Vivek2456 ,
please send sample data (not confidential) in text or excel form for at least 3 object_id. Thanks