Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
@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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |