The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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]
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.
Hi @Anonymous ,
how should it be your final report? Can you send some sample data?