Forum Discussion
Create Table in Power Query Editor by getting the unique values from other Table
Can i ask how can i create a table in the Power Query Editor by getting the distinct values of the columns from other tables?
Anonymous , You have to duplicate the table, Remove columns not needed. And then remove duplicates.
For one column, you can right click and generate list -> remove duplicate -> convert to table
refer these two
Power BI Tutorial Series for Beginners : Part 2 - Create Dimension Table https://www.youtube.com/watch?v=kU2M1LmNvNo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=2
Power BI Tutorial Series for Beginners: Part 3 - Separate out Dimension Table(Power Query) https://www.youtube.com/watch?v=vHuhbvYCiNc&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=3
1 Reply
Anonymous , You have to duplicate the table, Remove columns not needed. And then remove duplicates.
For one column, you can right click and generate list -> remove duplicate -> convert to table
refer these two
Power BI Tutorial Series for Beginners : Part 2 - Create Dimension Table https://www.youtube.com/watch?v=kU2M1LmNvNo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=2
Power BI Tutorial Series for Beginners: Part 3 - Separate out Dimension Table(Power Query) https://www.youtube.com/watch?v=vHuhbvYCiNc&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=3