New Column PBI

[SAGUILAR]

Hello,

I have the following table and I would like to create a new column only with the numbers on red. Thanks!

[wdx223_Daniel · Accepted solution]

=Table.FillDown(Table.AddColumn(PreviousStepName,"Custom",each if [Column1] is number and [Column2]=null and [Column3]=null then [Column1] else null),{"Custom"})

[SAGUILAR]

That worked. Thank you so much!!