Best practice for recreating calculations from a Power BI

[Aviator0807]

Thank you

[DawnDuong]

hi @Aviator0807 

You will need to first join the 5 separate tables into 1 big table and then use the formula tool to create new columns for the calculated columns.

Dawn.

[cgoodman3 · Accepted solution]

You are correct about needing to join the data together in Alteryx as it doesn’t have relationships in the same way as Power BI does. Make sure you check your relationships so not as to explode your data, for example are the relationships one to one or many to many?

The calculations are likely to be a mixture of formula (calculation is done at a record level) and multi-row formula tools (e.g if you are calculating month over month movements).

On the last part of your question, I’d potentially leave it as one massive table (as I assume there is a reason you are bringing the process into Alteryx), but if it’s to go back into Power BI again then splitting back to the multiple tables would be preferred for performance.