Forum Discussion
Solved
Use Table as a variable in a measure
Hello, I need to create a Measure that first group the lines by Date (summarizing) and then return the minimum date that have the sum lower than zero. I try to create the following measure, ...
apiccolotto , Try like
Stock_Cover test =
MINX(filter(SUMMARIZE('Stock Cover','Stock Cover'[Date],"Quantity",sum('Stock Cover'[Sum of Init Stock - Outflow + On Orders[Volume]]])),[Quantity]<0),[Date])
apiccolotto , Try like
Stock_Cover test =
MINX(filter(SUMMARIZE('Stock Cover','Stock Cover'[Date],"Quantity",sum('Stock Cover'[Sum of Init Stock - Outflow + On Orders[Volume]]])),[Quantity]<0),[Date])
Thanks a lots, it works.
A.