Forum Discussion
Automated calculation for two different sharepoint folder paths
I have two different tables from a sharepoint folder. One table contains the sales data and the other one contains the costs. I want to create a column in the sales data table which calulates the win...
Hi Anonymous ,
Yes,if the 2 tables are in the same sharepoint folder,you could connect it with power bi using sharepoint folder connector,then do the combine and transfrom to combine the data loaded in,also you could create a new column using calculations.Once your data is updated,click refresh,PBI will automatically updates the data with calculations.
Check the reference below:
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
Can you please provide some sample data and expected outcome?
It will be easier to answer your question if we have some data to work with.