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

Frequent Visitor

6 years ago

Apologies all, think I've confused matters by giving excel table not Power BI table.

Basically what I need to do is calculate the %age of plan for a different groups, the columsn in my Power BI table are:-

Month

Cost Centre

Expense Code

CC Description

EH Description

Description - NEW

Group

Divisional Grouping

CDG

National Specialty

Exp Group 2

I&E

Exp Group 4

NHSI Cat 1

Value

First calculation needs to be a SUM of the value column where EXP Group 2 = EXP Group 2 and National Specialty = National Specialty and Month = Month

This value to then be divided by sum of value column where National Specialty = National Specialty and Month = Month and colum I&E is either 'Pay' or 'Non Pay'

Thanks Craig