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.
In this blog we are going to take the approach of creating a Table, that will provide us data at the day level.
Read more...