Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
How can I add or combine the values from table1 "Columns" Code & City & Serial to shown the below result?
Thanks
Gaurav
Code | City | Serial | Result |
CH | JFK | ANBHK998 | CHJFKANBHK998 |
BH | LAS | 879898 | BHLAS879898 |
Solved! Go to Solution.
@gauravnarchal
Add the following column to combine:
Result = Table[Code] & Table[City] & Table[Serial]
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
PQ method:
Dax method:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
PQ method:
Dax method:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@gauravnarchal
Add the following column to combine:
Result = Table[Code] & Table[City] & Table[Serial]
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |