Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all.
Need to create a new collumn with text + Collumn + text + Colum
Example:
Table
Column: Year 2014, 2015, 2016, 2017, 2018
Column: Order 12,13,14,15,16,17...
New Column with "http:mywebsite.com" + Table[Year] + "ord" + Table[Order]
Solved! Go to Solution.
Hi @Anonymous,
Please create a custom column with this formula:
"http:mywebsite.com"&Text.From([Year])&"ord"&Text.From([Order])
Hope it helps otherwise let us know.
Ninter
Details
Year and Ord is a Number
ty
Hi @Anonymous,
Please create a custom column with this formula:
"http:mywebsite.com"&Text.From([Year])&"ord"&Text.From([Order])
Hope it helps otherwise let us know.
Ninter
in Power Query or Dax?
Ty
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |