Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.