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

Ashish_Mathur 

I know the answer is to combine SEGMENT_C field from SALES Table and SEG field from SEGMENT Table, But i don't know how to write to code .

My PBI file :-

https://www.dropbox.com/s/4ufqp99gpnp9ek5/PBS_VER0252%20Ask%20how%20to%20combine%20SEG%20field.pbix?dl=0

Hi,

Try this calculated column formula

SEGMENT_M = 'SALES'[SEG] & LOOKUPVALUE(SEGMENT[SEGMENT_C],SEGMENT[SEG_RAW],SALES[SEG])

Hope this helps.

Ashish_Mathur 

Thank you very much for your expression , it work fine. for

SOURCE = LE , SD , PW ,PM, DA

But for SOURCE = TS , TA, TP , TI it display as "A02Business Partner" instead of "Business Partner"

Can you help me to add one more condition to below expression , that is only perform LOOKUPVALUE for SOURCE = LE , SD , PW ,PM, DA

SEGMENT_M = 'SALES'[SEG] & LOOKUPVALUE(SEGMENT[SEGMENT_C],SEGMENT[SEG_RAW],SALES[SEG])

Wish you happy new year

Paul

Hi,

Share the download link of the PBI file.  Where is the source column - in which table?

Ashish_Mathur 

Appreciate very much for your help. i encloed below link is the PBI sample file , with detail explanation in the page.

https://www.dropbox.com/s/wh91oq9alv9c5p2/PBS_VER0275.pbix?dl=0

Paul

Ashish_Mathur 

Happy new year to you , Thank you very much , you code make my table look nice.

To you as well.  Glad to hear that my solution is working.