How to combine two data

could you pls provide the sample data and expected output?

Given your information, a possible answer is to use PowerQuery or SQL to union your data, and then create a measure to calculate the average.

You can provide some more info like where are the data sourced from, the structure of it, what column(s) do you want to get the average from, etc, for a more specific solution.