Showing results for 
Search instead for 
Did you mean: 
New Member


Hello Community,


My end goal is that for any null value to retrieve the value from the previous column. For example, null from Stars.2 row 2 = Stars:Chris Wood, Sarah Michelle Gellar, Lena Headey, Mark Hamill from Stars.1 row 2


What needs to change in the following formula to execute the code below successfully.

IF(ISBLANK([STARS.2]]),LOOKUPVALUE('Table'[[STARS.1]],'Table'[Row ID],EARLIER('Table'[Row ID])),[[STARS.2]])




With appreciation.



Super User
Super User

Hi @Passion_fruit_4 ,


Is it this you are looking for? 










Here the code in M that you can paste into the advanced editor to figure out the steps:

    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJUitWJVjICsvJKc3LAHGNkjgmQ4wRmmcJZZsgKzIEcZzDLAlnYEpljaIDCA9nrAmEaIZgIa2MB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"null",null,Replacer.ReplaceValue,{"Column2"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value",{{"Column1", Int64.Type}, {"Column2", type text}}),    
    #"Replace Values" = Table.ReplaceValue(#"Changed Type",each [Column2],each if [Column2] is null then [Column1] else [Column2],Replacer.ReplaceValue,{"Column2"})

    #"Replace Values"


Hope this helps!



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Super User
Super User

Create a new column in Power Query


if [Stars.2] = null then [Stars.1] else [Stars.2]


Then delete Stars.2 and only load Stars.1 and the new column. Or, delete the Stars.1 column if you don't need that in Power BI.


The "null" above is a keyword and must be all lower case. It will turn green in the editor. Cannot be Null or NULL. 

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors