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.
help me and sorry for my english!!
I have this situation in powerpivot
Customer Number | Customer Name | Inv number | Invoice Date | Due Date | Eur | dso | ISO | Stato |
01003 | aa | 010020792 | 20190211 | 20190318 | 5,4 | 60 | GB | Incassata |
01003 | aa | 10020793 | 20190618 | 20190718 | 6,71 | 10 | GB | Da incassare |
GB00063 | bb | 10020794 | 20181106 | 20181106 | 15,85 | 95 | GB | Incassata |
GB00160 | cc | 10020795 | 20190606 | 20190830 | 9,86 | 15 | GB | Da incassare |
GB00160 | cc | 10020796 | 20190528 | 20190731 | 12,73 | 3 | GB | Da incassare |
GB00213 | dd | 10020797 | 20180628 | 20180831 | 15,74 | 80 | GB | Incassata |
GB00213 | dd | 10020798 | 20180628 | 20180831 | 16,15 | 50 | GB | Incassata |
GB00213 | dd | 10020799 | 20181015 | 20181231 | 16,48 | 60 | GB | Incassata |
GB00213 | dd | 10020800 | 20190102 | 20190401 | 16,48 | 10 | GB | Incassata |
GB00213 | dd | 10020801 | 20180903 | 20181130 | 18,74 | 15 | GB | Incassata |
GB00231 | cc | 10020802 | 20190315 | 20190531 | 20,11 | 2 | GB | Incassata |
GB00247 | ee | 10020803 | 20181224 | 20181224 | 12 | 2 | GB | Incassata |
GB01276 | ff | 10020804 | 20190331 | 20190331 | 5,28 | 50 | GB | Incassata |
I need a MESURE that make DSO*EUR and divide it by the total turnover EUR of each individual customer:
I have tried different formulas but it always divides me for the total of ALL customers and not for a single customer ....
help me please
Solved! Go to Solution.
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 |
---|---|
115 | |
101 | |
73 | |
70 | |
47 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |