Forum Discussion
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...
Cbishop ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if this cane help
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Appreciate your Kudos.
I need to take the value in column E and divide by the sum of Column E where the Group & month match, so on the first line of data, take the £53,724 divided by the sum of column E where column A = 'Gas' and column B = Apr