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>
Date
Item No.
Item Qty
Description
Amount
31/03/2019
In house
1
In houDe...