Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

Error msg when i try to combine 2 column data into 1 column

Hi All   Yesterday  @ALLUREAN  help me on below post   https://community.powerbi.com/t5/Desktop/what-is-the-expression-for-BRAND-M/td-p/2256952   Today I try to create a expression :- SEGM...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this calculated column formula

    SEGMENT_M_1 = if(SALES[SOURCE]="LE"||SALES[SOURCE]="SD"||SALES[SOURCE]="PW"||SALES[SOURCE]="PM"||SALES[SOURCE]="DA",'SALES'[SEG] & LOOKUPVALUE(SEGMENT[SEGMENT_C],SEGMENT[SEG_RAW],SALES[SEG]),LOOKUPVALUE(SEGMENT[SEGMENT_C],SEGMENT[SEG_RAW],SALES[SEG]))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi admin11 ,

 

These two columns are from different tables, you will need to have a correspondence between them before you can merge them.

Please show some sample data so that we could help.

 

Best Regards,

Jay