Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Need Help with SUMIFS from Excel into DAX

OP.PNGHi 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.

Formulae pic.PNGInterval Data.PNGattendance Data 2.PNGCPA Data.PNGAttendance Data.PNG

8 REPLIES 8
v-yalanwu-msft
Community Support
Community Support

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
Not applicable

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.

sorry I don´t see the column [Contact]

Anonymous
Not applicable

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

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?

vyalanwumsft_0-1669772348254.png

vyalanwumsft_1-1669772368599.png


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
Not applicable

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

Formulae pic.PNG

Anonymous
Not applicable

@mangaus1111 It should be like this.OP.PNG

mangaus1111
Solution Sage
Solution Sage

Hi @Anonymous ,

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.