Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Need to sum values of rows based on specific rows. You can see below sample data and the expected result.
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
@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 ?
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |