Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I have a data model that requires a significant number of (If Statements). I have 10 new columns that i created using If Statements. Based on the outcome of the If Statement there is either some text or a Blank. I now want to take thoes 10 created columns and merge them together in one calcuated column. I can't figure out the DAX to use when creating the column.
Below is an example of my data set
I assume it should be some sort of If Blank statement... but i can't get the syntext.
| Finding ID | Workflow 1 | Plan | Final Decision | WHAT I NEED in a single new column |
FND-123 | Needs Work | Needs Work | ||
| FND-345 | Series A | Series A | ||
| FND-456 | Close it out | Close it out | ||
| FND-678 | Needs work | Needs work | ||
| FND-908 | Close it out | Close it out |
Just add the column values together
New Column = [Workflow 1] & [Plan] & [Final Decision]
etc.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 20 | |
| 12 | |
| 11 |