Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Bonjour
I am trying to combine this URL https://www.xxx.com/ which is not part of my fields and "contract key" which is part of the fields available in my data set.
Any idea about a solution
Thanks
A
Solved! Go to Solution.
HI @frenchiedc87 ,
You can use CONCATENATE finction in Power BI to achieve this.
Something as below:
combinedValue = CONCATENATE("https://www.xxx.com/", Table1[COLUMN])
Replace Table1[COLUMN] in above dax with your contract key column.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
HI @frenchiedc87 ,
You can use CONCATENATE finction in Power BI to achieve this.
Something as below:
combinedValue = CONCATENATE("https://www.xxx.com/", Table1[COLUMN])
Replace Table1[COLUMN] in above dax with your contract key column.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Thanks
you can add an extra column to your table that concatenates URL and Key and create a function that will call this URL and return the data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |