Forum Discussion
Allocation Cost to days based on allocation rule
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 ...
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.