sumifs using multiple table dax

[v-shex-msft]

Hi @Anonymous ,

Power bi does not support sumif function, I'd like to suggest you use iteration functions to instead. (they allow you to set a table to do looping calculations on it with conditions)

Since I'm not familiar with excel expressions, can you please explain more about your excel formula calculation logic? (e.g. summary 'X' fields based on 'Y' category and conditions 'Z')

Regards,

Xiaoxin Sheng

[Anonymous]

hi thank you for the reply, 
do you have any sample solution that i can follow? would help so much thank u.

[v-shex-msft]

HI @Anonymous ,

It seems like you remove your snapshot, can you please share some sample data and expected result? It is hard to coding formula without any detail information.

Regards,

Xiaoxin Sheng