Forum Discussion
Daily Phasing Calculation
I am looking to create a measure that will calculate a daily forecast number based off the phasing provided in a separate table. Currently I just have a forecast number for a particular month and then the phasing percentage by day in a differnt table. However since the forecast date is just identified with a single day of the month, the whole forecast is eing applied to one day, typically the first day of the month. Basically lookng to spread this $100,000 over the whole month by day using the pct on the right
3 Replies
awitt1Temp , refer if this can help
Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798
Thanks,
This uses the closingbalancemonth function which doesn't really work here.
Hi awitt1Temp ，
Can you share with me some screenshots of your data after hiding sensitive data?
Thanks for your efforts & time in advance.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
