Forum Discussion
Anonymous
5 years agoNot applicable
Monthly Target
Hi I have a scenario like this. I have a fact table with 3 months worth of data. the monthly target is 70. Yearly target is 840. How do i compute for the Month over Month Targ...
MattAllington
Community Champion
5 years agoThanks for adding the additional information to the OP. There are quite a few things I would recommend (more later). A quick fix is as follows.
1. change the relationship between targets and Date to be
- Many to Many
- Date filters Targets
I assume that all months in the targets table are also in the date table (a requirement for this change).
It's not clear how the rawdata rolls up to "actual". If it is count of questions, then you could write
Target = sum(TargetsTable[target])
Actual = countrows(rawdata)
Tracking to target = [Actual] - [Target]
Add a table visual to a report, place Date[MonthName] and the measures as values.
Bigger issues*
- What happens next year? Your targets are at a month level, but each year has the same months.
- You may want to set the targets at the mmm-yyyy level
- Why do you have 2 relationships between Staff List and Raw Data? This looks suspicious to me.