Calculate & Merge Column of Sales Order

[ADSL]

Dear BI Community Team,

I have a sales order table and want to merge the column name "Customer Code" & "Salesman Code" into one column and apply the measure Distinct Count of the merge column.

Any Suggestion?

Thanks and Regards,

[lukiz84 · Accepted solution]

Hi,

MergedColumn := Sales[Customer Code] & Sales[Salesman Code]

YourMeasure = DISTINCTCOUNT(Sales[MergedColumn])

[ADSL]

Hi @lukiz84 ,

It's working. Thank you very much for your feedback and advise.

Best Regards,