How to report a measure( hours ) across the start time as shown in table pic

[vvadlapatla]

I only have one record as shown in below table. I would like to report that 3 hours starting from start date time at 7:00 am and showing it across 3 hrs from 7:00 Am. Please help. Thanks

Start Date Time	End Date Time	Hours worked	Section
24/3/2020 7:00:00 AM	24/03/2020 10:00:00 AM	3	Braefield to Quirindi

[amitchandak]

Refer to this. I bit complex example with dates also included

https://www.dropbox.com/s/5wo5jhzl488zy69/Minute_between%20Hours.pbix?dl=0

https://powerbi.microsoft.com/en-us/support/

[vvadlapatla]

I @amitchandak,

Thankyou for your Pbix file. I nearly worked that out but your tables have one to one relationship but my tables have many to one as you only have one record for each batch but my table will have multiple sections for each start and end time. so the relationshi is not working.

Please help. Would you please be able to Let me know how  I can post images and so I can show you where i am hving hickups. Thanks

[vvadlapatla]

HI Amit, thankyou for the  reply. Sorry the link doesn't work completely for me. I am trying to understand your PBIX file i have

downloaded.

May be i might not be clear enough in my question.

I only need to have 24hrs time on axis,as always i am reporting the next 24 hrs data, and then have a horizontal graph where it shows 7: 00 am to 10:00 am highlighted with the given section name in the data.

I can actually show you how i want but unfortunately i dont know how to attach a jpeg or a screen snip as my fairly new to this group. Please help.

[Greg_Deckler]

@vvadlapatla - To share a PBIX, just use OneDrive or Box or some other file sharing service and post a link to it.

[Greg_Deckler]

Column = DATEDIFF([Start Date Time],[End Date Time],HOUR)

If you want working hours, try: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Duration/m-p/481543#M182

[vvadlapatla]

HI Greg, thanks for your reply. I have working hours already in my data. May be i might not be clear enough in my question.

I only need to have 24hrs time on axis,as always i am reporting the next 24 hrs data, and then have a horizontal graph where it shows 7: 00 am to 10:00 am highlighted with the given section name in the data.

I can actually show you how i want but unfortunately i dont know how to attach a jpeg or a screen snip as my fairly new to this group. Please help.