Forum Discussion
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...
Sum of Duration = CALCULATE( SUM(SlaveData[duration]), FILTER( SlaveData, SlaveData[If Status Met] = 1 && SlaveData[slaveid] = 1 && Slavedata[datStart] = TODAY() ) )
hi
I have two simple questions, how do I calculate what is described below.
Year value
2019 200
2018 100
2018 100
2019 200
2019 100
2018 50
The average year = 2019 is 166.67
Add up if Year = 2019 is 500
Hi,
Drag Year to the row labels of your visual. Write these measures
Total = SUM(Data[Value])
Average = AVERAGE(Data[Value])
Hope this helps.
Thank you for the answer, with a formula like that do all of them count? What if only 2019 counted.
Hi,
Try it first and let me know if it does not meet your expectation.
yes working
