Forum Discussion
Jayadev
Helper I
8 years agoDistributing invoice value against batch
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...
- 8 years ago
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
v-juanli-msft
Community Support
8 years agoHi Jayadev
Do you put this formula in a calculate column?
You need select "create new table" and put this formula in.
Best Regards
Maggie
Jayadev
Helper I
8 years agoI 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.