Can Power Bi Do this?

Hi Knight4hire ,

If you want to combine data from two tables into a single table by matching data, this is possible in Power BI, as long as there is some kind of association between the two tables.
If you want to do some kind of calculation on the data in the table, Power BI comes with the calculation function of the data, and if you want to implement some more complex calculations, you can also try to use the DAX function to create measures, calculate columns, and calculate tables to achieve the functions you want.
If you want to perform data processing on the data in a table, Power Query is present in Power BI to facilitate data transformation.

Would it be convenient for you to provide some sample data and the desired result renderings (without any privacy data)? You don't need to provide the original data, you just need to create some test data by yourself according to the format of the original data. In the case of sample data, it is more convenient for me to provide you with a solution.

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.