Forum Discussion
First Time Fix
Hello, Could someone help me with a custom column for First time Fix please? I have 2x date columns and im looking to find out if the job was completed as a first time fix. Start Date F...
Open the Power Query Editor, and click on the Add Column tab. Select Conditional Column.
When the dialogue box opens, fill out new column name box and fill out the form:Column Name = start date
operator = equals
value = change to Select a Column and select finish date
output = Yes
Else = No
This should get you there.
Open the Power Query Editor, and click on the Add Column tab. Select Conditional Column.
When the dialogue box opens, fill out new column name box and fill out the form:
Column Name = start date
operator = equals
value = change to Select a Column and select finish date
output = Yes
Else = No
This should get you there.
Perfect, thank you!