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
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |