The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
13 | |
8 | |
8 |