Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
02-10-2021 05:20 AM
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