You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

How to create a calculated column with values from related tables So far, everything needed has been in the same table, but you can add a calculated column that depends on values in another table.