Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear Community,
I am struggling with a formula for the Occupation of Resources per Month.
My current formula:
Hi @Anonymous ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
Hello,
I created this little sample table. My actual data is imported and synced to Project for the Web.
Resource | Start | Finish | Task | Occupied Days |
Resource A | 2/1/2023 | 13/1/23 | Task A | 10 |
Resource B | 9/1/2023 | 3/2/2023 | Task B | 20 |
Resource A | 23/1/23 | 27/1/23 | Task C | 5 |
What I need is a matrix view that looks like the following:
Resource | Jan'23 | Feb'23 | Mar'23 |
Resource A | 15 | ||
Resource B | 17 | 3 |
The value numbers represent the amount of days a resource is occupied in total (tasks combined), calculated per month.
In my formula mentioned in the first message it would give value 10 days in Jan 23 for Resource A, and not calculate the sum (=15). For Resource B it would give only the 17 in Jan 23 and does not calculate the days that are in the next month due to overlap.
Any ideas how to fix this?
Best,
Fabian
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
55 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
40 |