If cell is blank, add value from another column

[Anonymous]

Hello, I'm working to clean up a Decomposition Tree and ran into a challenge with blanks. I'm looking to have a query in M that says the following: 

=IF( [L9] is "" then insert value from column [Name and Position])  

Thank you!

[SylwiaRotterdam]

Power BI transpose data, does not provide cell details as "L9"?

[Mariusz · Accepted solution]

Hi @Anonymous 

Try this

= if [L9] = "" then [Name and Position] else [L9]

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn