Power BI Sum Formula For Total Values based on common numbers from another column

MuhammadZiaUrRehman

New Member
Joined
May 14, 2016
Messages
9
Hey guys.
I need to create a column in Power BI that is based on other columns from the table. For Example in the following table. It should be based on such criteria as to that the last column should total the 4th column based on document numbers and if the total is not equal to zero then the outstanding amount should reflect in the row containing Bill for that Document number and others should show negative of receipt value.
Please guide me if someone can in this regard.
7/1/2017
7/1/2017
7/1/2017
8/1/2017
8/1/2017
8/1/2017
9/1/2017
9/1/2017
9/1/2017
10/1/2017
10/1/2017
10/1/2017
11/1/2017
11/1/2017
11/1/2017
12/1/2017
12/1/2017
12/1/2017
1/1/2018
1/1/2018
1/1/2018
2/1/2018
2/1/2018
2/1/2018
3/1/2018
3/1/2018
3/1/2018
4/1/2018
4/1/2018
4/1/2018
5/1/2018
5/1/2018
5/1/2018
6/1/2018
6/1/2018
7/1/2018
7/1/2018
7/1/2018
8/1/2018
8/1/2018
8/1/2018
9/1/2018
9/1/2018
9/1/2018
10/1/2018
10/1/2018
10/1/2018
11/1/2018
11/1/2018
11/1/2018
12/1/2018
12/1/2018
12/1/2018
1/1/2019
1/1/2019
1/1/2019
2/1/2019
2/1/2019
2/1/2019
3/1/2019
3/1/2019
3/1/2019
4/1/2019
4/1/2019
4/1/2019
5/1/2019
5/1/2019
5/1/2019
6/1/2019
6/1/2019
6/1/2019
7/1/2019
7/1/2019
7/1/2019
8/1/2019
8/1/2019
8/1/2019
9/1/2019
9/1/2019
9/1/2019
10/1/2019
10/1/2019
10/1/2019
11/1/2019
11/1/2019
11/1/2019
12/1/2019
12/1/2019
12/1/2019
1/1/2020
1/1/2020
1/1/2020
2/1/2020
2/1/2020
2/1/2020
3/1/2020
3/1/2020
3/1/2020
4/1/2020
4/1/2020
4/1/2020
5/1/2020
5/1/2020
5/1/2020
6/1/2020
6/1/2020
6/1/2020
7/1/2020
7/1/2020
7/1/2020
8/1/2020
8/1/2020
8/1/2020
9/1/2020
9/1/2020
9/1/2020
10/1/2020
10/1/2020
10/1/2020
11/1/2020
11/1/2020
11/1/2020
12/1/2020
12/1/2020
12/1/2020
1/1/2021
1/1/2021
1/1/2021
2/1/2021
2/1/2021
2/1/2021
3/1/2021
3/1/2021
3/1/2021
4/1/2021
4/1/2021
4/1/2021
5/1/2021
5/1/2021
5/1/2021
6/1/2021
6/1/2021
6/1/2021
7/1/2021
7/1/2021
7/1/2021
7/1/2021
8/1/2021
8/1/2021
8/1/2021
8/1/2021
10/1/2021
10/1/2021
10/1/2021
10/1/2021
11/1/2021
11/1/2021
11/1/2021
11/1/2021
12/1/2021
12/1/2021
12/1/2021
12/1/2021
8000025
8000025
8000025
8000297
8000297
8000297
8000551
8000551
8000551
8000674
8000674
8000674
8000839
8000839
8000839
8001030
8001030
8001030
8001136
8001136
8001136
8001279
8001279
8001279
8001546
8001546
8001546
8001666
8001666
8001666
8001929
8001929
8001929
8002067
8002067
8000032
8000032
8000032
8000180
8000180
8000180
8000407
8000407
8000407
8000527
8000527
8000527
8000651
8000651
8000651
8000950
8000950
8000950
8001041
8001041
8001041
8001173
8001173
8001173
8001410
8001410
8001410
8001583
8001583
8001583
8001858
8001858
8001858
8002008
8002008
8002008
8000045
8000045
8000045
8000346
8000346
8000346
8000678
8000678
8000678
8000838
8000838
8000838
8001145
8001145
8001145
8001751
8001751
8001751
8002089
8002089
8002089
8002363
8002363
8002363
8002679
8002679
8002679
8003033
8003033
8003033
8003473
8003473
8003473
8003685
8003685
8003685
8000064
8000064
8000064
8000516
8000516
8000516
8000866
8000866
8000866
8001136
8001136
8001136
8001487
8001487
8001487
8001777
8001777
8001777
8002048
8002048
8002048
8002205
8002205
8002205
8002473
8002473
8002473
8002766
8002766
8002766
8003039
8003039
8003039
8003121
8003121
8003121
8000129
8000129
8000129
8000129
8000288
8000288
8000288
8000288
8000942
8000942
8000942
8000942
8001157
8001157
8001157
8001157
8001365
8001365
8001365
8001365
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Exchange Diff
Bill
Receipt
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Exchange diff
Bill
Receipt
Receipt
Exchange diff
Bill
Receipt
Receipt
Exchange diff
Bill
Receipt
Receipt
Exchange diff
Bill
Receipt
Receipt
Exchange diff
Bill
Receipt
Receipt
Receipt
36816920
-36822237
5317
77788412
-77794978
6566
109868311
-109874686
6375
100688746
-100626944
-61802
110543290
-110527940
-15350
288618568
-288773588
155020
284152877
-284140251
-12626
254178038
-254281739
103701
208551174
-208509371
-41803
205417715
-205437363
19648
120783466
-120753579
-29887
119256071
-119256071
94446347
-94435913
-10434
117393902
-117388740
-5162
75838002
-75833010
-4992
127344988
-127347292
2303
65659935
-65638871
-21064
80685162
-80667608
-17554
73993044
-73987518
-5526
53480974
-53469918
-11056
35707582
-35698500
-9082
-5356
30379417
-30374061
41546032
-41540500
-5532
38244843
-38236085
-8758
43838322
-43831791
-6531
27629992
-27626693
-3299
30396633
-30389310
-7323
45980541
-45978316
-2225
29746869
-29746527
-342
30964042
-30960324
-3718
25457052
-25452886
-4166
34773244
-34771208
-2036
14530169
-14529322
-847
3299392
-3298928
-464
13380939
-13375382
-5557
17220376
-17216821
-3555
16720497
-16801811
81314
9862119
-9854177
-7942
20404511
-20396519
-7992
9952181
-9949773
-2408
9386621
-9384026
-2595
15769965
-15765602
-4363
19351784
-19346113
-5671
21707719
-21700374
-7345
20034621
-20028796
-5825
12064334
-12060193
-4141
5571562
-5569395
-2167
17059717
-17048198
-11519
10222035
-8729605
-1485253
-7177
23080489
-19721015
-3353576
-5898
3045790
-2602504
-442551
-735
6171423
-896703
-5274689
-31
8500971
-1166
-1235184
-7264620
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,215,069
Messages
6,122,953
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top