Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hello,
I have so many columns on original table, I tried to merger both the tables, datas are duplicatiing. because it is whenever First column has value thne second column is empty and vice versa.
Is there way we can achieve thru query?
Avian
Hi,
We are a bit unclear about your question about Unique values,
However, as per our understanding,
You can append Query in Power Query Editor, Please follow the steps below,
1. Duplicate the Required Table,
2. Remove the first column and rename the second column in the original table,
3. Remove the Second column and rename the first column in the Duplicate table,
4. Navigate to the Append Queries,
5. Choose the table to Append
In the below sample table, we are looking to combine Both date fields in one as Date,
Please refer the below screenshots,
After Updating the tables,
Navigate to the Append as new, (Top - Right)
After Append the Tables,
Let us know if this is an expected result for you or if not then could you explain more about your query with sample data?
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at crm@inogic.com
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
View solution in original post
Hello
I tried as you suggested unfortunately I am getting duplicate records.
I have so many columns, I implemented as you suggested, first column showing value and second column showing null, Second column showing values, first column is showing null. And because of this records are duplication.
Is there any way?
Avian
Hello
Can anyone please help on my above question
Avian
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 crm@inogic.com
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/