Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have created a calculated table using existing table which gives distinct values from table i.e newtable= DISTINCT(table(column). I am trying to merge the newtable with other table in the model but I am not seeing newtable in power query editor or in the merge. Can you please let me know how to do it.
Thanks
Susheel
Solved! Go to Solution.
@Anonymous , for that, create a table is power query.
refer these two videos from tutorial series
refer: https://youtu.be/vHuhbvYCiNc
@Anonymous
you can try to create a reference table in the PQ.
remove the rest columns and remove duplicate
Proud to be a Super User!
@Anonymous Calculated table created in power bi will not be visible in powerquery window. As table is calculated and is being created in powerbi window, you will not be able to merge in powerquery window. You may need to create either in your source file or in powerquery window to be able to merge it with other table.
Proud to be a Super User!
@Anonymous , for that, create a table is power query.
refer these two videos from tutorial series
refer: https://youtu.be/vHuhbvYCiNc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |