Forum Discussion

Cbishop's avatar
Cbishop
Frequent Visitor
6 years ago

SUMIFS function in Power BI

Hi,   I am stuck on how I can apply the following SUMIFS formula into Power BI   =E2/SUMIFS(E:E,A:A,A2,B:B,B2)*100 Re-worked with column names (=Cost 2020/21 - Plan/SUMIFS(Cost 2020/21 - Plan,Gr...
Need Help
Cbishop's avatar
Cbishop
Frequent Visitor
6 years ago

Hi All,

 

Unfortunately all the suggestions didn't complete the required final result and as such I am unable to accept one as a solution.

 

I have managed to find a workaround to adhere to tight deadlines and will be revisiting this in due course.

 

Best Regards

 

Craig 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Cbishop 

    Could you share your workaround and mark it as the solution? More people will benefit from it. 

    Best Regards,

    Rico Zhou