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 am new to Power BI so would really apprechiate some help with this question as it will help me progress my dashboard.
I have a table called JOBS that has 3 fields im interested in JOB NUMBER, JOB_RAISED_DATE and SK_JOB_RAISED_DATE.
I am wanting to create a measure to Count how many distinct/unique JOB_NUMBERs have been raised within a MONTH.
I have an active relationship between my JOBS table and a CALENDAR table. The active relationship is CALENDER[DateAsInterger] and JOBS[SK_JOB_RAISED_DATE]. The relationship is 1 to Many.
Any help would be apprechiated as once i can solve this i can apply the same measure to calculate other montly measures
Thanks
Solved! Go to Solution.
No Problem @Anonymous. Glad I could help.
Please mark my reply as a solution to help others members of the community find answers that work. 😊
Hi @Anonymous,
Assuming there is nothing odd with your data here, like duplicate Job Numbers, your measure should be reasonably straignt forward:
JobCount = COUNTX(Jobs, Jobs[Job_Number])
You can then use this alongside your Calendar[Date] field to summarise by Year/Quarter/Month/Day.
Cheers,
Andy
Thanks @Anonymous that makes sense now and works as i expected it.
You many see some more help requests if the future as i familiarise myself with Power BI
Thanks again
No Problem @Anonymous. Glad I could help.
Please mark my reply as a solution to help others members of the community find answers that work. 😊
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |