Distributing invoice value against product batches

Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Tue Jun 05, 2018 3:13 pm

Distributing invoice value against product batches

Postby jayadev » Wed Jun 06, 2018 3:21 pm


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.

Please use this link.
https://docs.google.com/spreadsheets/d/ ... =388332244


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 0 guests