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.
Hi my friends,
Please help me,
I want to add column in tabel.
How to sum numbers in the row as many as the numbers in a column.
Here is the data sample and my expected result in last column.
I want to sum up item 1 until item 10 as many as 8 in row 1
Passage_item | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | Result |
8 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 5 |
9 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 6 |
9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 9 |
10 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 6 |
10 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 7 |
Thanks for Help
Solved! Go to Solution.
@LA_Enjoy
Please refer to attached sample file for all the details. The solution invoves many steps but all are simple.
@LA_Enjoy
Please refer to attached sample file for all the details. The solution invoves many steps but all are simple.
Thanks man
I used this formula in excel
=SUMIF($B$1:$K$1;"<="&$A2;$B2:$K2)
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |