Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear Expert,
I have a data set as below which stores the task information.
Task Name | Start Date | End Date |
A | 11/5/2018 | 11/9/2018 |
B | 11/7/2018 | 11/8/2018 |
C | 11/7/2018 | 11/9/2018 |
D | 11/6/2018 | 11/8/2018 |
I wish to create a table to track the workload of each date. The workload is based on the number of task in progress (start but not end). By using the tasks above, following table is the expected output:
11/5/2018 | 1 |
11/6/2018 | 2 |
11/7/2018 | 4 |
11/8/2018 | 4 |
11/9/2018 | 2 |
Is it possible to achieve that?
Many thanks!
Best regards,
Tom
Solved! Go to Solution.
hi, @TomLU123
After my test, you could do these as below:
Step1:
Create a complete calendar table
Step2:
Use crossjoin create a new table
Table = FILTER(CROSSJOIN(Table1,'Date'),'Date'[Date]>=Table1[Start Date]&&'Date'[Date]<=Table1[End Date])
Step3:
then drag the date field form new table and count Task Name
here is my pbix, please try it.
There's another way for you to refer to
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Best Regards,
Lin
hi, @TomLU123
After my test, you could do these as below:
Step1:
Create a complete calendar table
Step2:
Use crossjoin create a new table
Table = FILTER(CROSSJOIN(Table1,'Date'),'Date'[Date]>=Table1[Start Date]&&'Date'[Date]<=Table1[End Date])
Step3:
then drag the date field form new table and count Task Name
here is my pbix, please try it.
There's another way for you to refer to
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Best Regards,
Lin
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |