Forum Discussion
How to add rows value based on another rows??
Need to sum values of rows based on specific rows. You can see below sample data and the expected result.
jacky201995 , Create a new column like
if([Item] = "Soda" , [Input] + sumx(filter(Table, [item] ="Tea"),[Bad]), [Input])
How about if i have multiple rows at with same value of Item of "Tea"group by Date ?