Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Is there a DAX formula that enables one to allocate different percentages of total cost to individual month. For example the rules are the project duration have to be divided into two. Cost allocated to the final month of each phase have to be 20% of that phase and the rest of the 80% allocated equally across the remaining months for that particular phase. The objective is to be able to determine cost per month for different projects
Project No | Start Date | End Date | Total Cost | Project Duration | Mid Point Date | Cost Allocated/Phase |
001 | 01/01/2020 | 31/12/2020 | 200000 | 12 | 01/06/2020 | 100000 |
002 | 01/02/2020 | 01/09/2020 | 350000 | 7 | 01/06/2020 | 175000 |
003 | 01/05/2020 | 01/02/2021 | 300000 | 9 | 01/10/2020 | 150000 |
Hi @Anonymous,
What is the expected result with the data provided?
Jan