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]))
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

This should typically be a calculated column formula (not a measure) in the Sales table.

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

Ashish_Mathur 

 

I cannot find calculated forumla :-

Hope you can share with me .

 

Paul

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Click on the Data tab in the left hand side vertical panel, select the appropriate Table and then write the formula in that table.

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

      Ashish_Mathur 

      I have try still get error . Do you mean below :-

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        4 years ago

        Now click on the New Column button appearing in the ribbon.