Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am trying to create a column(containing hyperlink) using value from another column. Tried creating custom columns but no luck. I am importing data from a read-only database.
Desired output:
ID Link
2345 www.microsoft.com/2345/home
3346 www.microsoft.com/3346/home
Thanks!
Solved! Go to Solution.
Redo to this:
Hyperlink = "www.microsoft.com/"& FORMAT(Table[ID];"#") &"/home"
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @satmeh ,
Did you format the column as hyperlink after creating it?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelixThanks for your response. I wanted to learn how to create the desired links using 'ID' from other column.
Thanks!
Hi @satmeh ,
You need to create a column similar to this:
Hyperlink = "www.microsoft.com/"& Table[ID] &"/home"
Regards,
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRedo to this:
Hyperlink = "www.microsoft.com/"& FORMAT(Table[ID];"#") &"/home"
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |