Distributing/Allocating the Monthly Target (Convert to Daily Target)-Part 1: New Measures- Daily/MTD

Whenever we have targets, typically, they're at the month or 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 month 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.

 

Measures need 

 

Daily Target = CLOSINGBALANCEMONTH(sum(Target[Month Target])/(maxx(Target,DATEDIFF(Target[Month Date],Target[Date],day))+1),'Date'[Date])

MTD Target = CLOSINGBALANCEMONTH(sum(Target[Month Target])/(maxx(Target,DATEDIFF(Target[Month Date],Target[Date],day))+1),'Date'[Date]) *TOTALMTD(COUNT('Date'[Date]),'Date'[Date])

eyJrIjoiMDQ3ZjYwM2YtZjJhMi00ODczLThmOWMtOWQ0Y2RlZmMyZGMzIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9