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

Sorry but the Date/Time option is greyed out?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Then the value your measure is returning isn't a valid date. To be honest I'm not surprised; I don't see how a sum of durations would ever equal a calendar date. It doesn't make sense. What date is 5 hours 27 minutes + 3 days 8 hours 12 minutes, for instance?

  • chrisread9907's avatar
    chrisread9907
    Frequent Visitor
    9 years ago

    Yes that is true, i was looking for a 24 hour clock displaying the total duaration.

    My total durations will never go over 23:59 

     

    Even if both are formatted as number i get 'cant display the visual' error

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      What kind of visual are you trying to use this in?

      • chrisread9907's avatar
        chrisread9907
        Frequent Visitor
        9 years ago

        So, I have a 2 duation columns one formated as a number in seconds, one formated as time in hours, 

         

         

        I would like it to appear in a visual table, i can then also refrence it in another measure.