Forum Discussion
jcastr02
Post Prodigy
Post ProdigyCustom column based on whats contained in a row
I was trying to create a custom column in power query (a yes/no column is fine) that if any of the values in the row contains *00:00, the FE Yes/No column would be "No, if not then "Yes" see below...
Hi jcastr02 ,
Please try:
= Table.AddColumn(#"Changed Type", "Custom", each if List.ContainsAny({Record.Field(_, "FE Sat Open"), Record.Field(_, "FE Sat Close")}, {"*00:00"}) then "Yes" else "No")Best Regards,
Bof
Create a new step by clicking FX button and then paste that code in Editor, what you're doing is pasting the code in a custom column.
jcastr02Post Prodigy
Post ProdigyHello Anonymous Thanks so much. I tried to enter this , however getting different answers when the values are the same in the rows. Any ideas? Thanks so much.
AntrikshSharma
Community Champion
Community ChampionCreate a new step by clicking FX button and then paste that code in Editor, what you're doing is pasting the code in a custom column.