Forum Discussion
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 Target to check whether a respondent is meeting the monthly Target and would total to Year.
Would love to know how I could solve the problem.
the grain of data is daily and my target is monthly.
The target table i just created it. and looks something like the below.
MonthTarget
| January | 70 |
| February | 70 |
| March | 70 |
| April | 70 |
| May | 70 |
| June | 70 |
| July | 70 |
| August | 70 |
| September | 70 |
| October | 70 |
| November | 70 |
| December | 70 |
Thanks in advance
3 Replies
You need to help us to help you. https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906
Thanks 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.
