Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jacky201995
Frequent Visitor

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_0-1610612393649.png

 

3 REPLIES 3
v-yuaj-msft
Community Support
Community Support

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
Super User
Super User

@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 ?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.