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.
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
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
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*
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...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |