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.
I am looking to get an average # of units sold per person by the # of days they worked in the month. I had added a calendar and was able to get a daily average in the month based on number of days in the month but am stuck here. I added a days worked table but don't know what it needs to join and get the correct results. Any help would be greatly appreciated - a sample of my detail is below.
Thanks!!
Solved! Go to Solution.
Welcome to Power BI. There is a lot to learn.
The units table and days worked tables are data/fact tables. They are at different levels of granularity (one is day, one is month). If the data is small, a simple solution would be.
1. create an employee lookup/dim table with all unique employee names
2. create a month level calendar table (Read more here) https://exceleratorbi.com.au/power-pivot-calendar-tables/ Yours should be month level, not day level.
3. add a new calculated column in the units table to convert the date to the month.
4. join both data tables to both lookup tables on the relevant columns.
5. add employee and month from the lookup tables to a matrix
6. write measures for number of days worked, sum of units sold and [units]/[days]
Welcome to Power BI. There is a lot to learn.
The units table and days worked tables are data/fact tables. They are at different levels of granularity (one is day, one is month). If the data is small, a simple solution would be.
1. create an employee lookup/dim table with all unique employee names
2. create a month level calendar table (Read more here) https://exceleratorbi.com.au/power-pivot-calendar-tables/ Yours should be month level, not day level.
3. add a new calculated column in the units table to convert the date to the month.
4. join both data tables to both lookup tables on the relevant columns.
5. add employee and month from the lookup tables to a matrix
6. write measures for number of days worked, sum of units sold and [units]/[days]
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |