Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Data shared through Google Sheets
Solved! Go to Solution.
Hi @Jayadev
Do you put this formula in a calculate column?
You need select "create new table" and put this formula in.
Best Regards
Maggie
Hello @Jayadev
Sorry for not being able to help you currently since usage of DAX within PowerPivot is different from that in Power BI Desktop.
Please turn to PowerPivot technical forum for better help.
Best Regards
Maggie
Could nout find active forum of Powerpivot. Please share me the DAX in Powerbi.
Thanks in advance and request experts to help me.
Hi @Jayadev
Would you like use some feature in query editor, as tested, I found it will be more simple when using DAX along with query editor in Power BI desktop.
1.In query editor, merge table “BlendSheet” and “Inv”.
2.Then expand columns in Invoice table.
3.Create a new table using DAX in table BlendSheet in the Data view
Table1 = SUMMARIZE ( BlendSheet, [BLEND], [ESTATE], [GRADE], [bags], [net], [total], [%], [Batch], [Invoice.INVNO], [Invoice. VALUE ], "distrubution", [%] * [Invoice. VALUE ] )
Here is my pbix for your reference.
Best Regards
Maggie
I get this error, Please help
Hi @Jayadev
Do you put this formula in a calculate column?
You need select "create new table" and put this formula in.
Best Regards
Maggie
I think I made a mistake, rectified now and no error.
However, the distributed value is not matching.
Let me check once again.
Many many thanks for your support.
Thank you very much, appreciate a lot.
Will check and seek further help if needed.
Once again, Thanks.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |