Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create reports that show employee perfomance over time by measuring multiple dimension.
One of the dimensions that I am trying to show is if an employee has performed a task in each hour of the day (8 hour max).
I am currently getting a unique count of the hour field for each employee.
If the unique count is 8 or more, the score is 100%. If the unique count is 6, the score is 75% (6/8).
I have this formula working as a calculated column on the employees row in the employee table. I am alos "rolling" this up to show on an overall department level.
There are many other formulas or dimensions that I am looking to create.
Is a calculated column the best way to do this or is there another option?
Creating reports to measure employee performance over time involves considering various dimensions and metrics. While calculated columns can be useful for certain scenarios, there are alternative approaches in Power BI that might better suit your needs. Let’s explore some options:
Calculated Columns:
Measures (DAX):
Matrix Visuals and Slicers:
Custom Visuals and KPI Cards:
Hierarchies and Drill-Through:
Advanced Analytics and AI:
Row-Level Security (RLS):
In summary, while calculated columns can be useful for certain scenarios, measures (DAX) are often more flexible and efficient for dynamic calculations. Consider a combination of measures, visuals, and advanced features to create comprehensive employee performance reports.
Remember that the best approach depends on your specific requirements, data model, and user experience. Experiment with different options to find what works best for your organization. 😊
@AnalyticsWizard
Thank you for the response, however I am still not sure what the best way to go about this is.
I have created calculated columns and they are working as intended but I need a way to "store" these values.
The dashboard shows a realtime look at my data but I need to have the abiliy to calulate these scores for previous time periods and be able to see how each employee scored over the past year or past quarter.