Forum Discussion

AlexAlberga727's avatar
AlexAlberga727
Resolver II
6 years ago
Solved

Retrieving LASTDATE when another column = 0

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 invento...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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. 

saraMissBI's avatar
saraMissBI
Resolver I
6 years ago

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