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.
I need some help with combining two columns into one within my report. I can not use the Power Query Editor for a couple factors, and therefore would like a new column within the same table.
This is a sample of what the current table looks like:
Row Number | ID1 | ID2 |
1 | 123456 | |
2 | 456789 | |
3 | 321456 | |
4 | ||
5 | 654132 | |
6 | 789456 | |
7 | 987456 |
Intended result
Row Number | ID1 | ID2 | IDCombined |
1 | 123456 | 123456 | |
2 | 456789 | 456789 | |
3 | 321456 | 321456 | |
4 | |||
5 | 654132 | 654132 | |
6 | 789456 | 789456 | |
7 | 987456 | 987456 |
I have tried using the concatenate, union, and addcolumn functions however I keep running into errors, including scalar value issues.
Any help is greatly appreciated!
Solved! Go to Solution.
Can you not use something like if column2 = blank then column1 else column2? I'm assuming that there's not instances where there might be data in both columns at the same time that you might need to combine
Can you not use something like if column2 = blank then column1 else column2? I'm assuming that there's not instances where there might be data in both columns at the same time that you might need to combine
Sometimes the simplest solutions stare you in the face 🙂 Thank you!
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 |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |