Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |