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.
Good day,
I just started working with Power BI and am still learning. Could someone please assist me with a formula.
In my data I have the number of services we do on our equipment vs the potential number of service. I would like to calculate the percentage of the number of services we do per month (We call the services we do "Hits")
A created a new measure: Hit Rate YTD = SUM('Data Hit Rate-YTD'[TP Completed Events (Hits)]) / SUM('Data Hit Rate-YTD'[Total Potential Events]) but this does not give the a percentage per month.
I have a seperate column with the date. Do I have to include this in my calculation?
Solved! Go to Solution.
@Susan_Colyn,
Create the following columns in your table.
Year = YEAR('Data Hit Rate-YTD'[Date])
Month = MONTH('Data Hit Rate-YTD'[Date])
Then create a table visual as shown in the following screenshot.
Regards,
Lydia
@Susan_Colyn,
Create the following columns in your table.
Year = YEAR('Data Hit Rate-YTD'[Date])
Month = MONTH('Data Hit Rate-YTD'[Date])
Then create a table visual as shown in the following screenshot.
Regards,
Lydia
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |