topic Re: Retrieving LASTDATE when another column = 0 in DAX Commands and Tips

Retrieving LASTDATE when another column = 0

AlexAlberga727 — Fri, 21 Aug 2020 14:26:48 GMT

Folks -

Im looking for a solution to something I would imagine to be very simple. Please help!

In the below screenshot you will see a visual which illustrates when specific product's inventory levels go to 0. Once 0, another column starts to calculate "Days not Allocated". I would like to retrieve the LASTDATE that SKU had a Days Not Allocated of 0.

For the selected SKU that date would be 5/27/2020.

If anymore information is need please let me know.

Thanks!

Re: Retrieving LASTDATE when another column = 0

Greg_Deckler — Fri, 21 Aug 2020 14:30:49 GMT

AlexAlberga727 - Perhaps:

Measure = MAXX(FILTER('Table',[Avail Qty] > 0),[Date])

If a column. If a measure, create a table variable that represents the data in your visual (summarized by date for instance, use ADDCOLUMNS to add your measure, do your MAXX over that table variable.

Re: Retrieving LASTDATE when another column = 0

saraMissBI — Fri, 21 Aug 2020 16:52:55 GMT

Hi AlexAlberga727

Try the following:

measure = CALCULATE(LASTDATE(Table[Date]), [DaysNotAllocated] = 0)

If my answer resolves your issue, please give Kudos and mark as solution.

Thank you

Re: Retrieving LASTDATE when another column = 0

Anonymous — Fri, 21 Aug 2020 21:25:34 GMT

There doesn't seem to be enough information in your post in order to give you a good answer.

Re: Retrieving LASTDATE when another column = 0

AlexAlberga727 — Mon, 24 Aug 2020 15:29:38 GMT

Greg_Deckler

Thanks for chiming in and providing me a solution.