Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SumIF function like in Excel in Power

Hi, I'm new to this and I hope someone can help me. I'm having issue on sumif functions in power bi. I can't figure it out how to solve this. 

On my excel, I have this formula on column Q: = (1- ([@Overdue]/[@[total expected folder]]))*[@[total expected folder]]/SUMIF(A:A,A2,P:P)

 

Note: the [total expected folder] is the sum of M0 ex to M7 Ex in column P

I can't find ways how to have functions like SumIf in excel in power bi. 

 
 
 

 

 

 

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous ,Not very clear.

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.