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.
Dear All,
I am trying to create a formula that calculates the cost on a revenue days to late.
To creat this formula I made a few measures:
- Average revenue per day
- Average day's to late
- Total revenue per day to late.
These measures I created:
Solved! Go to Solution.
@Anonymous , I need some data to understand the problem. Can you share sample data and sample output in table format?
Now the product is always correct at line level means
SUm(A*B), NOT Sum(A)*Sum(B)
So in case you have to do Sum(A)*Sum(B) then you need to use context with values or summarize
Is your result just the product of your first two measures?
Total Revenue to Late = [Average Revenue Per Day] * [Average Days To Late]
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Is your result just the product of your first two measures?
Total Revenue to Late = [Average Revenue Per Day] * [Average Days To Late]
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat,
That worked, so I think thats the same as @amitchandak meant with =Sum(A)*Sum(B).
Thanks a lot for your support!
@Anonymous , I need some data to understand the problem. Can you share sample data and sample output in table format?
Now the product is always correct at line level means
SUm(A*B), NOT Sum(A)*Sum(B)
So in case you have to do Sum(A)*Sum(B) then you need to use context with values or summarize
Thanks a lot for your reply,
I don't understand the part of SUM(A*B), NOT Sum(A)*Sum(B)
Below I have pasted a part of the data set I use in table format, is this useful?
Thanks!
Account | DocumentNo | C/I | Doc. Date | Clearing | Dun | Amount | PayT | Days | Days to late |
75149089 | 66120774 | Invoice | 10/01/2020 00:00 | 24/02/2020 00:00 | 9100 | 45D | 45 | 0 | |
75174471 | 66123082 | Invoice | 14/01/2020 00:00 | 09/04/2020 00:00 | 14460 | 45D | 86 | 41 | |
75174471 | 66123595 | Invoice | 15/01/2020 00:00 | 11/03/2020 00:00 | 4650 | 45D | 56 | 11 | |
75174471 | 66123596 | Invoice | 15/01/2020 00:00 | 11/03/2020 00:00 | 8054 | 45D | 56 | 11 | |
75174471 | 66168226 | Invoice | 16/01/2020 00:00 | 21/02/2020 00:00 | 912 | 45D | 36 | -9 | |
75174471 | 66168264 | Invoice | 16/01/2020 00:00 | 08/04/2020 00:00 | 4395 | 45D | 83 | 38 | |
75174471 | 66168299 | Invoice | 16/01/2020 00:00 | 11/03/2020 00:00 | 5096.5 | 45D | 55 | 10 | |
75149089 | 66128697 | Invoice | 21/01/2020 00:00 | 06/03/2020 00:00 | 67.5 | 45D | 45 | 0 | |
75149089 | 66128716 | Invoice | 21/01/2020 00:00 | 06/03/2020 00:00 | 3190 | 45D | 45 | 0 | |
75149089 | 66128749 | Invoice | 21/01/2020 00:00 | 06/03/2020 00:00 | 180 | 45D | 45 | 0 | |
75174471 | 66129215 | Invoice | 22/01/2020 00:00 | 11/03/2020 00:00 | 3997.5 | 45D | 49 | 4 | |
75174471 | 66129216 | Invoice | 22/01/2020 00:00 | 11/03/2020 00:00 | 6467.5 | 45D | 49 | 4 | |
75174471 | 66156268 | Invoice | 24/01/2020 00:00 | 24/02/2020 00:00 | 4274 | 45D | 31 | -14 | |
75149089 | 66134708 | Invoice | 28/01/2020 00:00 | 13/03/2020 00:00 | 4765 | 45D | 45 | 0 | |
75149089 | 66134712 | Invoice | 28/01/2020 00:00 | 13/03/2020 00:00 | 7885 | 45D | 45 | 0 | |
75149089 | 66134737 | Invoice | 28/01/2020 00:00 | 13/03/2020 00:00 | 1700 | 45D | 45 | 0 | |
75174471 | 66135116 | Invoice | 29/01/2020 00:00 | 11/03/2020 00:00 | 79095.5 | 45D | 42 | -3 | |
75174471 | 66135117 | Invoice | 29/01/2020 00:00 | 11/03/2020 00:00 | 6565 | 45D | 42 | -3 | |
75149089 | 66143650 | Invoice | 07/02/2020 00:00 | 23/03/2020 00:00 | 14420 | 45D | 45 | 0 | |
75149089 | 66148667 | Invoice | 13/02/2020 00:00 | 30/03/2020 00:00 | 4315 | 45D | 46 | 1 | |
75149089 | 66155581 | Invoice | 21/02/2020 00:00 | 08/04/2020 00:00 | 3755 | 45D | 47 | 2 | |
75174471 | 66160226 | Invoice | 27/02/2020 00:00 | 11/03/2020 00:00 | 912 | 45D | 13 | -32 | |
75174471 | 66160227 | Invoice | 27/02/2020 00:00 | 11/03/2020 00:00 | 255 | 45D | 13 | -32 | |
75174471 | 66189690 | Invoice | 07/04/2020 00:00 | 30/04/2020 00:00 | 32.5 | 45D | 23 | -22 | |
75149089 | 68630611 | Invoice | 05/06/2020 00:00 | 20/07/2020 00:00 | 13440 | 45D | 45 | 0 | |
75174471 | 68651872 | Invoice | 01/07/2020 00:00 | 31/07/2020 00:00 | 398 | 45D | 30 | -15 | |
75174471 | 68651873 | Invoice | 01/07/2020 00:00 | 31/07/2020 00:00 | 922 | 45D | 30 | -15 | |
75169632 | 5605127 | Invoice | 02/01/2020 00:00 | 14/02/2020 00:00 | 110.11 | 45D | 43 | -2 | |
75169632 | 5605128 | Invoice | 02/01/2020 00:00 | 14/02/2020 00:00 | 1351.35 | 45D | 43 | -2 | |
75169632 | 5605129 | Invoice | 02/01/2020 00:00 | 14/02/2020 00:00 | 7230.3 | 45D | 43 | -2 | |
75160389 | 5605186 | Invoice | 02/01/2020 00:00 | 28/02/2020 00:00 | 50 | 30D | 57 | 27 | |
75160389 | 5605187 | Invoice | 02/01/2020 00:00 | 28/02/2020 00:00 | 383.88 | 30D | 57 | 27 | |
75160389 | 5605220 | Invoice | 02/01/2020 00:00 | 08/04/2020 00:00 | 130.4 | 30D | 97 | 67 | |
75169630 | 5605654 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 318.18 | 45D | 46 | 1 | |
75169630 | 5605679 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 818.8 | 45D | 46 | 1 | |
75169630 | 5605683 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 1161.45 | 45D | 46 | 1 | |
75169630 | 5605684 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 1517.78 | 45D | 46 | 1 | |
75169630 | 5605686 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 3791.34 | 45D | 46 | 1 | |
75169630 | 5605687 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 3671.57 | 45D | 46 | 1 | |
75169630 | 5605688 | Invoice | 03/01/2020 00:00 | 18/02/2020 00:00 | 8858.22 | 45D | 46 | 1 |
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |