Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
sharpedogs
Advocate II
Advocate II

Added Columns - I'm not sure how to do a calculated column using DAX

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 IDWorkflow 1Plan Final DecisionWHAT I NEED in a single new column 

FND-123

Needs Work  Needs Work
FND-345 Series A Series A
FND-456  Close it outClose it out
FND-678Needs work  Needs work
FND-908  Close it outClose it out

 

1 REPLY 1
lbendlin
Super User
Super User

Just add the column values together

 

New Column = [Workflow 1] & [Plan] & [Final Decision]

 

etc.

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.