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.
if(isblank([Code1],[Code2],[Code1]))
i'm trying to merge 2 columns using above but it's not working in power BI but do work in excel. help
Solved! Go to Solution.
@Anonymous
If you're talking about a calculated column, it should work. Just fix a little syntax error.
if(isblank([Code1]),[Code2],[Code1])
Or mergring columns
CONCATENATE([code1],[code2])
I am trying to merge two columns, Zip and Country for Lab 2.
1. create a new column
2. using "Concanate", the formula showing says "Column = CONCANATE ()
3. when I try to click on the first line of the zip field to select the first data to concanate, it highlights the entire column, no matter how I click and the formula doesn't show until I click back on it. But each time it does not add that as the first data field.
I'm stuck how to combine two columns for Lab two for CountryZip
Charlsie
@Anonymous
If you're talking about a calculated column, it should work. Just fix a little syntax error.
if(isblank([Code1]),[Code2],[Code1])
Or mergring columns
CONCATENATE([code1],[code2])
It seem that this formula dose not wark on big data (I have 65K rows) is it posible?
I tried this but it still returns first column, here is my DAX formula "IF(ISBLANK(PNL[Job No_]), CONCATENATE(PNL[Job No_] , PNL[Job_Order No_]) , PNL[Job No_])"
what am I doing wrong?
@Anonymous - you can merge two columns in the query editor. Select the columns you want to merge and then in the ribbon you will see merge columns.
Giles
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |