Forum Discussion

sachingarg's avatar
sachingarg
New Member
9 years ago
Solved

SUMIF in Power BI Desktop?

I have two columns Product ID and value. The Product ID is repeated several times in the data and I need to do a sum of value for each Product ID and store this into a new column such that the same s...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi sachingarg,

    If your table has no index column, please firstly add index column to your column in Query Editor of Power BI Desktop. Then in Power BI Desktop Report view, create the following calculated columns by right-clicking your table and selecting “New Column”, this way you will get expected result in a table visual.

    SumColumn = CALCULATE(SUM(Table[Lost Service]),ALLEXCEPT(Table,Table[Sales Order Number]))
    Service Level Met = IF(Table[SumColumn]<1,"Achieved","Lost")

     


    Thanks,
    Lydia Zhang

sachingarg's avatar
sachingarg
New Member
9 years ago

Hi,

 

Thanks I have added the snapshot of the data on how it is working in EXCEL but unable to get my head around how i can do this in Power BI

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago

    Hi sachingarg,

     

    Looking at your information I want to understand better what you need to get.

     

    You want to have the Service Level Met column filled with Achieve/Lost based on the fact that the column lost service is 0 or 1?

     

    I understand you formulas but not the result you want to achieve, so I can help you better.

     

    Regards,

    MFelix