Need Help with SUMIFS from Excel into DAX

[Anonymous]

Hi Everyone,

We're planning to convert all the Excel files to Power BI. I am experiening the difficulty in converting the SUMIFS to DAX. I have tried in DAX but it is showing the error. I request someone to help me clearing the issue.

[v-yalanwu-msft]

Hi, @Anonymous ;

The information you provided is still a bit vague, can you send a simple complete example and the result you wish to output? So that we can understand the logic behind it and solve it faster.

Solved: How to upload PBI in Community - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Click here to access the link 


I have shared the Sample data set. There is a column names Contact and that is the output that I am looking for.

[mangaus1111]

sorry I don´t see the column [Contact]

[Anonymous]

@mangaus1111 It's in the AC Column in the Attendance Data. 

[v-yalanwu-msft]

Hi, @Anonymous ;

Sorry, I still don't understand the logic corresponding to the result you want, there is no corresponding sumif formula in the attachment you provided, I can't know, which result do you hope to get? How did this result come about?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yalanwu-msft my bad. I'll attach the formuale here.

[Anonymous]

@mangaus1111 It should be like this.

[mangaus1111]

Hi @Anonymous ,

how should it be your final report? Can you send some sample data?