Forum Discussion
Sumifs Calculation
Hi frds,
I have doubt in Sumifs calculation in power Bi.
Please help me.
Thanks,
Kali
Anonymous ,
In case you need a new column
sumx(filter(Table,Table[Group] = earlier(Table[Group]) && Table[Product] = earlier(Table[Product])),Table[Spare capacity]) Or sumx(filter(Table,Table[Group] = earlier(Table[Group]) && Table[Product] = earlier(Table[Product]) && Table[year] = earlier(Table[year]) ),Table[Spare capacity])
3 Replies
Anonymous
You can try a new measure
Calculate(sum(Table[spare Capacity],allexcept(Table[Group])
Hi amitchandak Thank you,
thanks for your help,
in case i have summing sumifs in Group,Product,year
please help me.Thanks,
Kali
Anonymous ,
In case you need a new column
sumx(filter(Table,Table[Group] = earlier(Table[Group]) && Table[Product] = earlier(Table[Product])),Table[Spare capacity]) Or sumx(filter(Table,Table[Group] = earlier(Table[Group]) && Table[Product] = earlier(Table[Product]) && Table[year] = earlier(Table[year]) ),Table[Spare capacity])