Forum Discussion
Dax Help
Bsmart2gether, KT_Bsmart2gethe
Hello
i have a table like this. how can we extract the data from this and find the item aging and value.
Item Sale should be in FIFO Order based on Posting Date.once the 1st purchase consumed then only it should take from the 2nd sale.
aging slot of 0-30, 31-60,61-90,91-120,121-180,181-270,271-365,365 and above plus value also on each slot. (FIFO Method)
Entry types for Sale : Sale, Negative Adjustments
Entry types for Purchase : Purchase , Positive Adjustments.
Sample Data and down is the sample result
3 Replies
Hi@
could you pls share your mail so that i can share the data. here excel is not uploadingThankyou in advance
