Forum Discussion

Ranjith_96's avatar
Ranjith_96
Helper I
3 years ago

Tables with different level

Hi Power BI Community, Please find my below table structure. I have two tables: Orders and Marketing table 1. Order table has 4 columns - Date, Country, Channel and Total_Orders 2. Marketing tabl...
Need Help
gregoliveira's avatar
gregoliveira
Helper II
3 years ago

Hi.

You can deal with this situation better using DAX and relations between tables. I will need a calendar table and a country table. After this, you can author some measures to split the marketing spend based, for example, in the total orders.

However, if you need to accomplish this in Power Query, you can first aggregate the Orders table by Date and Country to sum the Orders per Channel and then merge this this table with the Marketing table.

Hope this help you.