Forum Discussion

moesteez's avatar
moesteez
Icon for Helper I rankHelper I
5 years ago
Solved

SUM quantity on a specific date

Im having a really hard time with a relaly basic measure but I cant figure out what Im doing wrong.   Ive got a quantity measure that sums a quantity column that works fine I have a calendar table...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    moesteez,

     

    Try this measure. You had the argument order wrong in the DATE function.

     

    Measure =
CALCULATE ( [Quantity], 'Calendar'[Date] = DATE ( 2021, 07, 07 ) )

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

moesteez,

 

Try this measure. You had the argument order wrong in the DATE function.

 

Measure =
CALCULATE ( [Quantity], 'Calendar'[Date] = DATE ( 2021, 07, 07 ) )