Calculated Table

[Anonymous]

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

[ryan_mayu]

@Anonymous 

you can try to create a reference table in the PQ.

remove the rest columns and remove duplicate

[negi007]

@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.

[amitchandak · Accepted solution]

@Anonymous , for that, create a table is power query.

refer these two videos from tutorial series

https://youtu.be/kU2M1LmNvNo

refer: https://youtu.be/vHuhbvYCiNc