Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

SylwiaRotterdam's avatar
SylwiaRotterdam
New Member
3 years ago

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