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
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 0 guests