I have the following measures
Total Target Bookings £ - calculates the target per month
Days in Period - calculates the # of days in the period
Daily Target - calculates the Total Target Bookings per day
PROBLEM
Actuals are entered by week number therefore the target needs to be split across months based on a daily target * # days in the period as below
Hi @AliB - Have tried to resolve your issues based on the understanding I got from above post.
Please check attached PBIX and page “Duplicate of Measures”. There are few new measures created to solve the issue. Let me know if helps or any further help is needed.
Thank you - this seems to work however when I try to use it in a cumulative measure it only gives me data for the 1st week therefore the line chart I’m trying to create for YTD as per the post doesn’t work ?
For Week 5 if we add the 12381.68 + 1927.57 we get the 14309.25 which is correct however if I remove the Period from the table we get this which puts Week 5 at 15993 instead of the 14309.25
Hi @AliB - Please find attached the solution for weekly target without Period. Primarily created a new measure as below and slight changes in existing measures.