Hi,
I have a quarter wise excel sheet in sharepoint, the structure of file (i.e columns are not same) is different.
Want to bring this data in power bi and have to pivot some columns and perform calculation in every excel file. Now, the requirement is set up the structure in such a way that the all calculations is done only once and then every quarter the data display dynamically.
I have checked the calcualtion is working fine individaully on every file , I have even tried to append all the files but then also its a manual task to do calculations every time a new file is added in sharepoint.
So, my question is can we do something dynamic here instaed of manually adding file and then pivoting it and doing all calculations.
Please help me on this.
Thanks
