Forum Discussion
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...
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.
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.
