build a new table using multiple excel files and apply calculation

[Anonymous]

Hello,

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

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

there is no relation between these files so the new table will be used as calculated table reference to build powerbi reports

Thanks,

Yousef

[camargos88]

@Anonymous ,

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

Ricardo

[Anonymous]

thank you for the reply @camargos88 

I was looking at these links they used power query to build the new table but the data was same structure

what if the data are not same structure and still want to build a table from different source/columns, can i use SELECTCOLUMNS to build this kind of table

https://radacad.com/combine-multiple-or-all-sheets-from-an-excel-file-into-a-power-bi-solution-using...

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

Thanks,

Yousef