Forum Discussion
Anonymous
6 years agoNot applicable
If cell is blank, add value from another column
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!
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
2 Replies
- SylwiaRotterdamNew Member
Power BI transpose data, does not provide cell details as "L9"?