Calculate Hours of a selected Month In a Duration

[TempoClick]

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.

[Greg_Deckler]

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

[TempoClick]

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?

[Greg_Deckler · Accepted 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