JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Power BI Sum Formula For Total Values based on common numbers from another column
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
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.
Threads
1,223,904
Messages
6,175,295
Members
452,632
Latest member
jladair