The equivalent Dax version of Excel Sumifs

[Anonymous]

Hello!

In excel I have a SUMIfs. 

Col A is employee, B is week number and C is hours. 

In column D my sumifs would be:

SUMIFS(C:C,A:A,A2,B:B,B2) or sumifs(hours, employee column, A2,week number column, B2)

Employee	Week Number	Hours
Dave	1	4
Mark	1	5
Jacob	1	6
Dave	2	6
Jacob	1	5
Jacob	2	4
Mark	2	3

I am having desperate trouble replicating this formula in BI.

Any tips or help would be greatly appreciated.

Thanks

WATER

[Anonymous · Accepted solution]

@Anonymous 

See if this post help out or at least can get you started:

https://community.powerbi.com/t5/Power-Query/Function-Excell-Countifs-in-Power-BI/m-p/708835#M23665

[Anonymous]

@Anonymous Hi Nick,

Many thanks for your help.

I was able to solve my issue with a variation of this formula:

CALCULATE(SUM(Table1[Hours]), FILTER(Table1, Table1[Employee] = EARLIER (Table1[Employee])), (Table1[Hours]),FILTER(Table1, Table1[Week Range] = EARLIER (Table1[Week Range])), (Table1[Hours]))

Many thnaks again