Forum Discussion

apiccolotto's avatar
apiccolotto
Regular Visitor
6 years ago
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, but it seems that I can't use table in the calculation (the underline text is an error).

 

Stock_Cover test =
var Table1 =
SUMMARIZE('Stock Cover','Stock Cover'[Date],"Quantity",sum('Stock Cover'[Sum of Init Stock - Outflow + On Orders[Volume]]]))
return CALCULATE(MIN(Table1.Date),Table1.Quantity < 0))
 
Thanks in Advance,
 
A.
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    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])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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])