Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Community!
I would need some tips to get my allocation problem solved properly.
I have a project with start date and end date. Then I have predicted costs and then an allocation rule that says for example that project is split into 4 splits (based on duration end date - start date). First step gets 10% of predicted cost, 2nd step 20%, 3rd step 20% and 4th step 50%. Cost should be allocated for each days, for example 10% of total cost should be allocated to days in the first step.
Example data:
ProjectID; StartDate; EndDate; AllocationRule; PredictedCost
ID1; 1.1.2019; 20.5.2019; Rule1; 100000€
AllocationRule; Allocation1; Allocation2; Allocation3; Allocation4
Rule1; 10; 20; 20; 50
Any Idea how this should be done?
Solved! Go to Solution.
Hi,
I got it sorted out.
The key was to add custom column in power query which creates days in range:
Table.AddColumn(#"Added Index", "Date", each {[StartDate]..[EndDate]})
After that it's just basic calculations and lookups to get allocation right.
Hi,
I got it sorted out.
The key was to add custom column in power query which creates days in range:
Table.AddColumn(#"Added Index", "Date", each {[StartDate]..[EndDate]})
After that it's just basic calculations and lookups to get allocation right.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |