Forum Discussion
Anonymous
3 years agoNot applicable
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...
- 3 years ago
Hi Anonymous ,
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.
Anonymous
3 years agoNot applicable
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.
- mangaus11113 years ago
Solution Sage
Hi Anonymous ,
please send sample data (not confidential) in text or excel form for at least 3 object_id. Thanks
- Anonymous3 years agoNot applicable
Sure I have uploaded the file in