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.
Hi,
I need to show in a table/matrix the days someone is gone based on from and to date:
Dataset includes datetable.
The dataset looks somewhat like this (3 columns):
Person from to
1 03.02.2020 07.02.2020
2 04.02.2020 07.02.2020
Desired matrix:
Weeknr 6
day Mon Tue Wed Thu Fri Sat Sun
person 1 1 1 1 1 1
person 2 1 1 1 1
Solved! Go to Solution.
You want a modification of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
Hi @Anonymous
Please see the attached file with a solution in Power Query.
Table - you sample
Table ( referenced ) - Table referenced to Table and Transformed to expand dates ( Added Colum step )
Calendar - list of dates + weekday column ( date dimension )
@Mariusz, nice solution with power query.
See dax solution by Greg_Dekler.
You want a modification of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
You want a modification of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
Refer this blog can help to deal with between date. Now instead of count of employee take sum of weekday
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |