Forum Discussion
How to add a Conditional Column in Power Query based on a Shift Pattern?
First step is to bring your data into usable format
and then you can add the column in the Faults table.
Note that I modified your sample data as it was missing the "before 7am" scenario.
.
lbendlin
Super User
Super UserPower Query doesn't really like nested "each" statements, it is hard to keep track of the scope. So it is simpler to use explicit functions instead. "k" is a random name for "current row of the outer scope" and you can reference it inside the function.
{0} is just saying "give me the first row of the Table.SelectRows". You could have used Table.First or other methods too.