Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

help, how to merge 2 columns

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    
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    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])
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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])
  • LevanZukhbaia's avatar
    LevanZukhbaia
    Frequent Visitor
    6 years ago

     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?

  • LevanZukhbaia's avatar
    LevanZukhbaia
    Frequent Visitor
    6 years ago

    It seem that this formula dose not wark on big data (I have 65K rows) is it posible?