Forum Discussion
Jeev125
Sep 09, 2020Copper Contributor
How to match events in same line using Power Query
I have a data set where i need match first Alarm and next Normal event into single line to find difference duration. i have attached a sample file with PQ uptill now. Need to get the output in one si...
Jeev125
Sep 11, 2020Copper Contributor
I am learning new every single day.
Hi Craig, your result is quite close but how do we capture this part where its an single event is there any way, check the attach snap.
Below snap is from Raw Data. Because the Equipment was at fault from 7th to 10th.
Craig Hatmaker
Sep 11, 2020Iron Contributor
Jeev125 ,
Change the merge join type from Inner to LeftOuter
= Table.NestedJoin(Alarms,{"Location", "Equipment", "ID"},Normals,{"Location", "Equipment", "ID"},"Normals",JoinKind.LeftOuter)