Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SAGUILAR
Frequent Visitor

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!

SAGUILAR_0-1712866629907.png

 

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

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

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

=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!!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors