Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
learnbcvibe
Frequent Visitor

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 resultSample Data and down is the sample result

 

 

3 REPLIES 3
learnbcvibe
Frequent Visitor

Hello @KT_Bsmart2gethe 

Hi @learnbcvibe,

 

Do you have the data handy?

 

Regards

KT 

Hi@

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors