cancel
Showing results for
Did you mean:

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.

Frequent Visitor

## Urgent Need help with dax for days of supply

Days of Supply =

// Get the current week and inventory for the current row

VAR __week = MAX('Inventory'[Week])

VAR __inventory = VALUES(Inventory[Inventory])

// Create a table of all weeks less than the current week

VAR __table = FILTER(ALL(Inventory),[Week]>__week)

// Add our current inventory from above to each row

// Add a running total of demand to each row

// Add the difference in start versus the running total of demand to each row

VAR __table3 = ADDCOLUMNS(__table2,"__left",[__start] - [__demand])

// Create a table that only has the positive rows

VAR __table4 = FILTER(__table3,[__left]>=0)

// With only the positive rows, the MIN is the last row before demand runs out

VAR __min = MINX(__table4,[__left])

// Therefore, our base days is the number of rows in this table * 7

VAR __baseDays = COUNTROWS(__table4)*7

// Grab the MAX value of the negative rows, this is the row right after our inventory runs out

VAR __max = MAXX(FILTER(__table3,[__left]<0),[__left])

// Divide the row right before the invetory ran out by the sum of the absolute values of right before and after

// the inventory ran out. This is the percentage of days in that week before inventory ran out. multiply this by 7

// and this is the number of days in that week before inventory ran out

VAR __extraDays = __min / (__min + ABS(__max)) * 7

RETURN

i want the days of supply column to be same as desired result can some one help me with the same

2 REPLIES 2
New Member

Hi @Kunal8886 we would be happy to help you out if you still need! https://www.freshbi.com/contact

Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors