Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a very basic problem, but due to my lack of knowledge in Power query, I cannot find out how to solve it.
As mentioned in the subject, I want to create a table from a list (or distinct value of anther table), pls show me how.
I have a data table, my purpose is create a table including distinct values of one column from that data table, but I cant do that.
So I created a list as below, then tried to create a table from the list, but still cant 😞
Many thanks
Solved! Go to Solution.
In the Transform menu, you will notice that you have something called To Table. Use that.
In the Transform menu, you will notice that you have something called To Table. Use that.
lol, OK. I spent a couple of hours tried to do that.
Anyway, is there anyway to create a table from distinct values of another table's column?
Thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
6 | |
6 | |
6 |
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |