Distributing/Allocating the Yearly Target (Convert to Daily Target) -Part 1 - New Table 10-29-2020 04:30 AM

[amitchandak]

Distributing/Allocating the Yearly Target (Convert to Daily Target) -Part 1 - New Table

Whenever we have targets, typically, they're at the month or at the year level. All are other data like sales purchase is typically at the level. Now we want to analyze both these data together there is a challenge one data is at the year level another data is at the day level. To deal with such scenarios we have options of creating a day level table or creating a measure that can give us the Day level target.

New Table Code

Daily Target = SUMMARIZE('Date', 'Date'[Date], Target[Year], "Daily Target" , CALCULATE(sum(Target[Target])/(DATEDIFF(min(Target[Start Year]),max(Target[Date]),day)+1)))

eyJrIjoiNDdjYWNlNDktOTcxMC00NDkyLThlOWUtYWRkYjU1OGE5N2U2IiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9

[pmargari]

Hello amitchandak,
How you will do it if your target is at quarter lever ? 
Thanks for your help