build a new table using multiple excel files and apply calculation

Question

Hello,&nbsp;I am trying to replace my old way of working with excel files and external linking so the calculation will be on summary excel file&nbsp;is this possible with powerbi desktop i want to load muiltlpe files and then select columuns from diffrent files/sheet and build a new table using DAX and do the calculation in powerbi insted of doing it in excel&nbsp;there is no relation between these files so&nbsp;the new table will be used as calculated table reference to build powerbi reports&nbsp;Thanks,Yousef&nbsp;&nbsp;&nbsp;&nbsp;

camargos88 · Answer

Anonymous&nbsp;,&nbsp;Yes, you can select the columns you need and shape your tables from different excel files and if necessary get all of them together.&nbsp;Ricardo

anonymous · Answer

thank you for the reply&nbsp;camargos88&nbsp;&nbsp;I was looking at these links they used power query to build the new table but the data was same structure&nbsp;what if the data are not same structure and still want to build a table from different source/columns,&nbsp;can i use&nbsp;SELECTCOLUMNS to build this kind of table&nbsp;https://radacad.com/combine-multiple-or-all-sheets-from-an-excel-file-into-a-power-bi-solution-using-power-query-dynamicallyhttps://insightsoftware.com/blog/power-bi-load-data-from-folder/&nbsp;Thanks,Yousef&nbsp;

Forum Discussion

build a new table using multiple excel files and apply calculation

2 Replies

Related content

CALCULATE with multiple filters

Build 2.151.1182.0 Error

Report building for multiple clients

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

Conditional formatting using multiple calculation groups