Forum Discussion

chrisread9907's avatar
chrisread9907
Frequent Visitor
9 years ago
Solved

SUMIF Function

Hi,   I am struggling to covert my SUMIF Excel formula to DAX,   This is my excel formula:   =SUMIFS('Slave Data'!$E:$E,'Slave Data'!K:K,"=1",'Slave Data'!$B:$B,"="&$B10,'Slave Data'!L:L,"="&H1...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago
    Sum of Duration = CALCULATE(
	SUM(SlaveData[duration]),
	FILTER(
		SlaveData,
		SlaveData[If Status Met] = 1 &&
		SlaveData[slaveid] = 1 &&
		Slavedata[datStart] = TODAY()
	)
)
chrisread9907's avatar
chrisread9907
Frequent Visitor
9 years ago

Thanks, So the written formula would be

 

SUM of SlaveData[duration] if Slavedata[If Status Met] =1 and if Slavedata[slaveid] =1 and if Slavedata[datStart] = today

 

Sorry for not explianing properly,

 

Chris

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago
    Sum of Duration = CALCULATE(
	SUM(SlaveData[duration]),
	FILTER(
		SlaveData,
		SlaveData[If Status Met] = 1 &&
		SlaveData[slaveid] = 1 &&
		Slavedata[datStart] = TODAY()
	)
)
    • chrisread9907's avatar
      chrisread9907
      Frequent Visitor
      9 years ago

      Thank you very much, how can i format this as a date to display it in a visual?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Measure formatting is in the Modeling tab.