Dax Help

[learnbcvibe]

@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

[learnbcvibe]

Hello @KT_Bsmart2gethe 

[KT_Bsmart2gethe]

Hi @learnbcvibe,

Do you have the data handy?

Regards

KT 

[learnbcvibe]

Hi@

@KT_Bsmart2gethe 

could you pls share your mail so that i can share the data. here excel is not uploading

Thankyou in advance

PREVIEW