Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello! New to PowerBi.... searched extensively but cannot find a solution!
I'm trying to create a table or some sort of visualization in PowerBi where I can see an employee's capacity on any given date.
I have two tables:
Table A (Projects) has the following columns: Project Name, Employee Name, Project Start Date, Project End Date, Workload (that the project is taking up of the employee's time)
Table B (Dates) - a list of dates from 1/1/2023 to 12/31/2026
Table A
Project Name | Employee Name | Project Start Date | Project End Date | Workload |
ProjectA | John | 1/1/2024 | 1/30/2024 | 30% |
ProjectB | John | 1/15/2024 | 2/15/2024 | 40% |
ProjectC | Nancy | 3/1/2024 | 3/31/2024 | 15% |
The table I want:
Date (every date of the year... just picking random dates to demonstrate goal) | John's Total Workload | Nancy's Total Workload |
12/31/2023 | 0% | 0% |
1/1/2024 | 30% | 0% |
1/20/2024 | 70% | 0% |
3/15/2024 | 0% | 15% |
I'd like to be able to see what an employee's workload looks like on any given day.
Here's what I've tried:
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
This worked, too! Thank you so much!
Incredible! Thank you for this solution!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |