Forum Discussion
Lookupvalue
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...
edhans
Community Champion
Community ChampionCreate 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.