Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@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.
Hi@
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |