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 request someone to help me clearing the issue.

Need Help
Show and Tell

8 Replies

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Anonymous ,

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

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

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

      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.