How to add rows value based on another rows??

[jacky201995]

Need to sum values of rows based on specific rows.  You can see below sample data and the expected result. 

[v-yuaj-msft]

Hi @jacky201995 ,

Based on your description, if there are multiple rows at with same value of Item of "Tea"group by Date, what kind of calculation logic do you want? Sum them up?
Sorry for that it's still not clear. Can you share some sample data and the expected result to have a clear understanding of your question? You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here. 

Best Regards,

Yuna

[amitchandak]

@jacky201995 , Create a new column like

if([Item] = "Soda" , [Input] + sumx(filter(Table, [item] ="Tea"),[Bad]), [Input])

[jacky201995]

How about if i have multiple rows at with same value of Item of "Tea"group by Date ?