How do I bring the link of any website (Say from CRM) into a particular column in the dashboard?

[tsarun1992]

Hi all,

I need to show the link in a column for the data on the web. 
It is continuous data which keeps adding daily hence there should not be any manual work.

Something like shown below.

If someone has already worked on it, please let know the possibilities.

[johnt75]

No, you only need to do this once. As new data is loaded the calculated column will automatically populate.

[johnt75 · Accepted solution]

Add a calculated column to the table along the lines of

Link to CMR = "https://www.example.com/path/to/page/" & 'Table'[ID]

Set the categorization of the column to Web URL. Add the column to your table visual, and under visual options you can turn on the URL icon.

[tsarun1992]

This solution worked buddy !! Thanks a Ton 🙂