Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a table with durations that looks like this:
Name | Start | End |
James | 31/01/2018 14:25:00 | 01/02/2018 21:29:00 |
Antonio | 12/02/2018 10:59:00 | 17/02/2018 1:13:00 |
I want to filter by Month and get the number of hours of the selected month in each duration.
How can I do that?
Thanks.
Solved! Go to Solution.
Well, I think that the right answer is to unpivot your Start and End columns so that you end up with:
Name,Type,Duration
James,Start,31/01/2018 14:25:00
James,End,01/02/2018 21:29:00
Antonio,Start,12/02/2018 10:59:00
Antonio,End,17/02/2018 1:13:00
So, do you want the difference between Start and End or ?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sorry. I don't need the difference between the two dates.
If you can see the first record in the table has a period spanning from January to February. I want the hours from January only. How can I do it?
Well, I think that the right answer is to unpivot your Start and End columns so that you end up with:
Name,Type,Duration
James,Start,31/01/2018 14:25:00
James,End,01/02/2018 21:29:00
Antonio,Start,12/02/2018 10:59:00
Antonio,End,17/02/2018 1:13:00
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |