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...
Riny_van_Eekelen
Sep 09, 2020Platinum Contributor
Jeev125 You can Fill - Up column "Normal" and then filter out "null" from the "Alarm column". Furthermore, I'd recommend that you remove unwanted columns via the query, rather than hiding and deleting them from the table loaded into Excel.
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.
- SergeiBaklanSep 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