ISNULL replicating in power bi

Question

I am very new to power bi. I am trying to write ISNULL related query in Power BI&nbsp;my SQL syntax&nbsp;CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + ' ' + LastName END AS FullName.&nbsp;can anyone help me how to replicate in Power BI&nbsp;

v-yalanwu-msft · Accepted Answer

Hi,&nbsp;Anonymous&nbsp;;
In power query , you could add custom column.
if [MiddleName]=null or  [MiddleName]=" " then [FirstName]&amp;" "&amp;[LastName]
else [FirstName]&amp;" "&amp;[MiddleName]&amp;" "&amp;[LastName]

The final show:

Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s0vSk/MU9JR8kpNzswrSQSylGJ1opWcgQxHIHZSio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [LastName = _t, FirstName = _t, MiddleName = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"LastName", type text}, {"FirstName", type text}, {"MiddleName", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Full Name", each if [MiddleName]=null or  [MiddleName]=" " then [FirstName]&amp;" "&amp;[LastName]
else [FirstName]&amp;" "&amp;[MiddleName]&amp;" "&amp;[LastName])
in
    #"Added Custom"
Best Regards,Community Support Team _ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

2 Replies

Related content