Distributing invoice value in another table

[devcochin]

Hi,

Please help me to build a DAX formula to address the following issue, I am planning to use POWERPIVOT to do this work.

In the shared link, there are 3 sheets, 1. BlendSheet, 2.Inv, 3. Required output.

Blend sheet contain the product mix in various ratios. The objective is to generate a monthly sales report from the current month invoice. The invoice value should be allocated against in item in a batch based on the ratios given in the blend sheet.

Please help me solve this problem.

LINK
https://docs.google.com/spreadsheets/d/1ikPHKxMzxa6LOgAWRSKvTZ_Qwaa5jST6GgzY1tAUnvM/edit#gid=388332244

 

[Matt Allington]

Maybe look at my article here. Not sure if it is what you need. https://exceleratorbi.com.au/many-many-relationships-dax-explained/