Create a dimension table from other tables - How?

[Anonymous]

I have three tables in my data model that strings together a variety of numeric identifiers and DAX functions for me to have a the desired output of Client, Campaign Name, Billing Code and Customer Code.  I'd like to create a dimension table by re-consuming particular columns from each of these tables, so that I have a simple table of of only the essential 4 columns I need.  (In PowerBI I can create the table I want  (visually), export the data and reimport it as another table), but that hardly seems efficient.

Is there a recommended process where I can create a New Table, including these 4 columns only, so that I can use it as a Dim Table without the export and import?

Thanks!

[Aron_Moore]

Under Modeling, New Table. Then https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax

Probably look something like DimTable = SELECTCOLUMNS('Massive Table', "Campaign', 'Massive Table'[Campaign Name]....

[Anonymous]

@Aron_Moore

And this will allow columns from different tables? Will it allow me to bring in a DAX created column?

[v-cherch-msft]

Hi @Anonymous 

You may try to use SUMMARIZE function or SUMMARIZECOLUMNS function.For further,please refer to below articles.

https://www.sqlbi.com/articles/introducing-summarizecolumns/

https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

Sample data or some assumed data and expected output which could reproduce your scenario will be helpful to provide an accurate solution.You can upload the .pbix file to OneDrive and post the link here or send me via private message. Do mask sensitive data before uploading.

Regards,

[v-cherch-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,