The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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