Custom Column to Concatonate values where NOT BLANK

[Matt0515]

Hello Experts:

I am trying to create a custom column of URL links for only lines that are NOT BLANK in another column.

I know how to make the final output an active link, I am having issues creating the logic in Power Query to ignore the lines with blank in the ID Column.

So in summary, I want to add "https://my.salesforce.com/" & [ID Column]

Sorry if this issue is solved on the boards somewhere, I have been searching all day and cant seem to find what I am looking for:

Example:          ID Column:         Desired Result:

Line1                ABCDEF             https://my.salesforce.com/ABCDEF

Line2

Line3                HIJKLMN            https://my.salesforce.com/HIJKLMN

Line4

Line5                1234567             https://my.salesforce.com/1234567

Thank you in advance for the help!

Matt

[nandic · Accepted solution]

@Matt0515 ,
In Power Query: Add new column > Custom Column:
Concatenate URL = if [ID] is null then null else "https://my.salesforce.com/"&[ID]
After that, save changes in Power Query and then set data category for this column to be Web url.