Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sumifs Calculation

Hi frds,   I have doubt in Sumifs calculation in power Bi.     Please help me.   Thanks, Kali    
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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])