Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost Patron
9 years ago

SUM values if date equal to

Hi,   Trying to SUM the values in column Num Hrs if iDate = 17 Marach 2017.   Have this so far -> Bank Hol = CALCULATE(SUM(CarerActualWork[Num Hrs]),CarerActualWork[iDate]= "17 March 2017")   b...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi android1

 

Please try this slight variation

 

Bank Hol = CALCULATE(
			SUM(CarerActualWork[Num Hrs]),
			CarerActualWork[iDate]= DATE(2017,3,17)
			)