Forum Discussion
Solved
New Column PBI
Hello, I have the following table and I would like to create a new column only with the numbers on red. Thanks!
=Table.FillDown(Table.AddColumn(PreviousStepName,"Custom",each if [Column1] is number and [Column2]=null and [Column3]=null then [Column1] else null),{"Custom"})
=Table.FillDown(Table.AddColumn(PreviousStepName,"Custom",each if [Column1] is number and [Column2]=null and [Column3]=null then [Column1] else null),{"Custom"})
That worked. Thank you so much!!
