Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Who can help me with the next question?
I have a table with trips
Trip | Start | End | Amount |
1002201 | 15-1-2019 | 2-3-2019 | € 15.000,00 |
1002203 | 20-1-2019 | 30-1-2019 | € 45.000,00 |
1002205 | 15-2-2019 | 10-3-2019 | € 23.000,00 |
Now i want to devide the amount over the months depending the days that the project is in that month
Days
Jan | Feb | Mrt |
16 | 28 | 2 |
10 | 0 | 0 |
0 | 13 | 10 |
Percentage
Jan | Feb | Mrt |
35% | 61% | 4% |
100% | 0% | 0% |
0% | 57% | 43% |
The result has to be like this
Jan | Feb | Mrt |
€ 5.217,39 | € 9.130,43 | € 652,17 |
€ 45.000,00 | € - | € - |
€ - | € 13.000,00 | € 10.000,00 |
Wiht kind regards
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |