Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help with SUMIFS from Excel into DAX

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 req...
Need Help
Show and Tell
mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

sorry I don´t see the column [Contact]

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

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