I'm trying to concatenate a [Full Title] column, combining values from a [Title] column and a [Subtitle] column. That bit seems pretty easy; "= [Title] & " " & [Subtitle]"
But some of the books don't have subtitles, so the concatenated column throws up a null.
How can I get the column to display the information it does have, even when the second value is missing?
Solved! Go to Solution.
Hmm... Using that exact forumula I'm receiving an Expression Error:
Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.