Automated calculation for two different sharepoint folder paths

[Anonymous]

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 for every month. When the new sales and costs data for the next months are added to the sharepoint folders, PBI should add automatically a new column to the new sales data file with the calculated win. Is this possible and if so, how do I realize this Idea?

[v-kelly-msft · Accepted solution]

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,
Kelly

Did I answer your question? Mark my reply as a solution!

[KNP]

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.