Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi. i try to rebuild a excel in powerBI.
Country | Sales Target | Budget |
DE | 198 313 800 | 211 151 483 |
AT | 59 737 000 | 60 895 812 |
CH | 30 227 467 | 29 684 932 |
IT | 73 839 000 | 88 879 020 |
FR | 25 172 000 | 25 187 918 |
ES | 11 070 560 | 11 159 557 |
NL | 15 420 000 | 15 742 907 |
BE | 9 209 000 | 9 392 804 |
UK | 8 339 904 | 8 514 919 |
TR | 5 416 160 | 4 509 283 |
SE | 28 106 865 | 29 359 101 |
FI | 3 735 380 | 3 901 801 |
DK | 17 591 002 | 17 790 188 |
NO | 1 489 256 | 1 506 120 |
CZ | 16 885 183 | 17 223 386 |
SK | 6 253 699 | 6 378 958 |
PL | 7 073 139 | 8 302 920 |
RU | 7 520 170 | 6 590 888 |
US | 59 887 207 | 59 079 975 |
CA | 16 188 281 | 16 462 609 |
BR | 3 620 442 | 3 726 906 |
CN | 75 585 163 | 77 170 899 |
TW | 1 920 806 | 1 961 103 |
IN | 20 307 530 | 20 736 483 |
KR | 12 223 519 | 12 749 150 |
SG | 4 358 709 | 4 312 913 |
JP | 8 403 105 | 8 579 031 |
Direct Sales | 13 849 401 | 14 118 060 |
BA | 7 727 115 | 7 877 010 |
ZZZ | -37 955 687 | |
i need to create 3 new columns:
Country | Sales Target | Budget | total sales | Anteil | total Budget | |||
DE | 198 313 800 | 211 151 483 | ||||||
AT | 59 737 000 | 60 895 812 | ||||||
CH | 30 227 467 | 29 684 932 | ||||||
IT | 73 839 000 | 88 879 020 | ||||||
FR | 25 172 000 | 25 187 918 | ||||||
ES | 11 070 560 | 11 159 557 | ||||||
NL | 15 420 000 | 15 742 907 | ||||||
BE | 9 209 000 | 9 392 804 | ||||||
UK | 8 339 904 | 8 514 919 | ||||||
TR | 5 416 160 | 4 509 283 | ||||||
SE | 28 106 865 | 29 359 101 | 31 842 244 | 88% | 33 260 902 | Total sales = SE+ FI | Anteil = SE /TotalSales | |
FI | 3 735 380 | 3 901 801 | 12% | 33 260 902 | Anteil = FI /TotalSales | |||
DK | 17 591 002 | 17 790 188 | 19 080 259 | 92% | 19 296 307 | Total sales =DK + NO | Anteil = DK /TotalSales | |
NO | 1 489 256 | 1 506 120 | 8% | 19 296 307 | Anteil =NO /TotalSales | |||
CZ | 16 885 183 | 17 223 386 | 23 138 881 | 73% | 23 602 343 | Total sales = CZ + SK | Anteil = CZI /TotalSales | |
SK | 6 253 699 | 6 378 958 | 27% | 23 602 343 | Anteil = SK /TotalSales | |||
PL | 7 073 139 | 8 302 920 | ||||||
RU | 7 520 170 | 6 590 888 | ||||||
US | 59 887 207 | 59 079 975 | ||||||
CA | 16 188 281 | 16 462 609 | ||||||
BR | 3 620 442 | 3 726 906 | ||||||
CN | 75 585 163 | 77 170 899 | 77 505 969 | 98% | 79 132 002 | Total sales = CN + TW | Anteil = CN /TotalSales | |
TW | 1 920 806 | 1 961 103 | 2% | 79 132 002 | Anteil = TW /TotalSales | |||
IN | 20 307 530 | 20 736 483 | ||||||
KR | 12 223 519 | 12 749 150 | ||||||
SG | 4 358 709 | 4 312 913 | ||||||
JP | 8 403 105 | 8 579 031 | ||||||
Direct Sales | 13 849 401 | 14 118 060 | ||||||
BA | 7 727 115 | 7 877 010 | ||||||
ZZZ | -37 955 687 |
any idea?
ThanX 🙂
Solved! Go to Solution.
You need to add a "Region" column.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |