Convert product wise yearly target to daily target

[Anonymous]

Hi! I have a table with product wise yearly target and I want to convert it to daily target to get YTD target.

First I created a table with dates, and then added two columns to the target table (fiscal year starts on 1st Oct):

   Start Year = Date(goals[fiscal year]-1,10,1)

   Date = date(goals[fiscal year],9,30)

And then I joined the two tables based on fiscal year. Then I added another table for daily target:

   Daily Target = SUMMARIZE('Calendar Table', 'Calendar Table'[Date], 'Calendar Table'[Fiscal year], "Daily Target" ,    CALCULATE(sum(goals[target])/(DATEDIFF(min(goals[Start Year]),max(goals[Date]),day))))

This does not work and I am not allowed to summarize by columns in GOALS table. Please help! 🙂

[amitchandak · Accepted solution]

@Anonymous , refer if 1 of 2 can help

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290