Forum Discussion

Jayadev's avatar
Jayadev
Helper I
8 years ago
Solved

Distributing 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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    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

Jayadev's avatar
Jayadev
Helper I
8 years ago

I get this error, Please help

 

 

v-juanli-msft's avatar
v-juanli-msft
Community Support
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

  • Jayadev's avatar
    Jayadev
    Helper I
    8 years ago

    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.