Forum Discussion
Creating a table of columns from another table
Hi Coffeinalytics,
One method you have already mentioned for creating a table out of another table is reference or duplicate in query editor. Then you can Choose Columns from the reference/ duplicate table and proceed
Another method is to use DAX in Data tab to create a table with specified columns.
https://dax.guide/selectcolumns/
https://learn.microsoft.com/en-us/dax/selectcolumns-function-dax
Though doing such transformation in M code/ query editor is usually faster and more beneficial than using DAX.
Solution SageHi Coffeinalytics,
One method you have already mentioned for creating a table out of another table is reference or duplicate in query editor. Then you can Choose Columns from the reference/ duplicate table and proceed
Another method is to use DAX in Data tab to create a table with specified columns.
https://dax.guide/selectcolumns/
https://learn.microsoft.com/en-us/dax/selectcolumns-function-dax
Though doing such transformation in M code/ query editor is usually faster and more beneficial than using DAX.