Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |