Forum Discussion

avi081265's avatar
avi081265
Icon for Helper III rankHelper III
3 years ago

How to combine two columns as one column with unique value

Hello,   I have two columns i.e. ProductionPlant and DevelopmentPlant, I want to combine both columns as one column with unique values.   What is best and eficient way to do this? Regards Avian...
Need Help
avi081265's avatar
avi081265
Icon for Helper III rankHelper III
3 years ago

Hello

 

Can anyone please help on my above question

 

Avian

SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

Hi avi081265 ,

 

You can use the DISTINCT DAX function in Power BI.

 

To retain unique cells, you'll need to create a new table. Refer to the DAX expression provided below:

 

New Table = DISTINCT( UNION( ALL('Sample Table'[Fruits]), ALL('Sample Table'[Another Fruits]) ) )

 

If this doesn't solve the issue, please share the current and expected output with us, ensuring sensitive data is obscured.

Thanks!

 

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/