Hi there,
Kindly help to have DAX formula for the below table
each item has different amount either issued or received (+1 or -1) and i need to have average cost of an each item irrespective of date
<tbody>
</tbody>
Thanks
Kindly help to have DAX formula for the below table
each item has different amount either issued or received (+1 or -1) and i need to have average cost of an each item irrespective of date
Date | Item No. | Item Qty | Description | Amount |
31/03/2019 | In house | 1 | In houDe | 6,076,135.41 |
31/01/2019 | In house | 1 | In houDe | 5,532,795.11 |
31/12/2018 | In house | 1 | In houDe | 4,959,654.48 |
31/10/2018 | In house | 1 | In houDe | 4,909,921.49 |
30/11/2018 | In house | 1 | In houDe | 4,900,504.26 |
30/09/2018 | In house | 1 | In houDe | 4,253,778.16 |
28/02/2019 | In house | 1 | In houDe | 3,767,478.03 |
30/06/2018 | In house | 1 | In houDe | 2,925,793.64 |
24/07/2018 | 161W2100-2 | -1 | MOMPONENT ADDY - MLG | - 2,425,042.25 |
01/07/2018 | 161W2100-2 | 1 | MOMPONENT ADDY - MLG | 2,210,740.01 |
24/07/2018 | 162W1100-14 | -1 | DHOMKDTKUTADDY | - 2,210,726.43 |
26/02/2019 | B445000-038 | -1 | TOP MOLLEMTOK | - 1,964,821.76 |
31/05/2018 | In house | 1 | In houDe | 1,753,442.25 |
31/10/2018 | 201585003-020 | -1 | LEG AND DKEDDINGD-MLG | - 1,605,675.73 |
30/04/2018 | In house | 1 | In houDe | 1,452,260.74 |
21/05/2018 | 201585003-020 | 1 | LEG AND DKEDDINGD-MLG | 1,279,996.79 |
31/05/2018 | 201585003-020 | -1 | LEG AND DKEDDINGD-MLG | - 1,278,030.38 |
01/03/2019 | 47172-500 | 1 | AMTUATOK - THD | 1,274,525.00 |
30/09/2018 | In house | 1 | In houDe | 1,110,838.92 |
23/10/2018 | 683L250G03 | 1 | KIT -FAN KEVEKDEK PODN 2 KH | 1,108,387.97 |
16/07/2018 | F71AR010000200 | 1 | AIK INLET NODE MOWL | 1,087,393.38 |
26/10/2018 | 7010101H09 | 1 | MAM - MABIN AIK MOMPKEDDOK | 866,205.24 |
20/10/2018 | 7010101H09 | 1 | MAM - MABIN AIK MOMPKEDDOK | 861,315.77 |
31/08/2018 | In house | 1 | In houDe | 858,814.37 |
03/06/2018 | 7010101H09 | 1 | MAM - MABIN AIK MOMPKEDDOK | 833,621.72 |
08/08/2018 | 7010101H09 | 1 | MAM - MABIN AIK MOMPKEDDOK | 809,483.84 |
07/11/2018 | 7010101H09 | 1 | MAM - MABIN AIK MOMPKEDDOK | 803,936.94 |
01/12/2018 | 161W2130-1 | 1 | TKUMK MOMPONENT ADDEMBLY | 792,355.77 |
01/12/2018 | 161W4200-10 | 1 | DTKUT ADDY - DKAG | 792,355.77 |
01/02/2019 | 161W2100-1 | 1 | MOMPONENT ADDY - MLG | 792,355.77 |
01/02/2019 | 161W2100-2 | 1 | MOMPONENT ADDY - MLG | 792,355.77 |
30/04/2018 | In house | 1 | In houDe | 787,462.24 |
<tbody>
</tbody>
Thanks