Monthly Target

[Anonymous]

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

[MattAllington]

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...

[Anonymous]

Hi Mat

Thanks for the reply. 

Is the detail that ive shared enough to atleast point me on how i could solve the problem?

Thank you

[MattAllington]

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.