Forum Discussion

JDSang's avatar
JDSang
Frequent Visitor
6 years ago
Solved

SUMIFS in Power Bi

Hi, i'm pretty new to power Bi and am struggling to get my head around tasks that are simple in excel, i have a list of orders each with multiple time entries by different people over various months....
Need Help
  • JDSang's avatar
    JDSang
    6 years ago

    dax edhans 

     

    I seem to have answered my own question. I used:

    Month Hours = CALCULATE(SUM('Table'[Hours]),ALLEXCEPT('Table','Table'[Month]))
    The month hours matches the total for month on the second table.
     
    Thank you for your help 🙂
JDSang's avatar
JDSang
Frequent Visitor
6 years ago

dax edhans 

 

I seem to have answered my own question. I used:

Month Hours = CALCULATE(SUM('Table'[Hours]),ALLEXCEPT('Table','Table'[Month]))
The month hours matches the total for month on the second table.
 
Thank you for your help 🙂
JDSang's avatar
JDSang
Frequent Visitor
6 years ago

Hi dax edhans 

 

So the code I used only worked when I filtered by month. when I unfilter everything it doesn't give the total hours for the Order in that month. i'm trying a few different things but am struggling to find the answer.