Forum Discussion

SAGUILAR's avatar
SAGUILAR
Frequent Visitor
2 years ago
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!

 

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

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

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

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