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 09, 2020Copper Contributor
Hi Riny, I cant use fill since the data is not consistent like Alarm & Normal. Also Fill copies UP or DN value to number of lines where my data doesn't follow the consistent patter. Also condition with Raw Data i cant miss any line that the condition too.
I have attach Sample photo with the issue where i have t match colour coded cells respectively.
SergeiBaklan
Sep 09, 2020Diamond Contributor
It looks like you need to merge the table with itself using Merged column, plus I think you don't need Date & Time column