Hi All, I have column of time values, but I wanted to have in 1 hour time range like 02 : 03

[Dharmendharan_L]

Hi, The first image is the time column I have, i wnated to have it time range (02:03)like the second image. Please share your ideas to achieve this. Thanks

@amitchandak 

[Dharmendharan_L]

@Ahmedx Thank you so much for spending your time and helping me out. I can create a table using this query. How can I create a calculated colum in the fact table using the hour column?.

[Ahmedx]

Can you please share your demo input and expected output!

[Dharmendharan_L]

The first image is the input i have in a table, its an hour column.

I want an calculated column in the same table showing time range like the 2nd image for the Input( 1st image).

Thanks @Ahmedx 

[Ahmedx · Accepted solution]

not sure if I understood you correctly but look at the file

https://1drv.ms/u/s!AiUZ0Ws7G26RiTiUwvgeGUU22U3M?e=40kAmG

[Dharmendharan_L]

Thank you so much @Ahmedx , This is what i wanted exactly.👏

[Ahmedx]

pls try this

TimePriod = 
SELECTCOLUMNS (
    ADDCOLUMNS (
        GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 0, 0 ), TIME ( 1, 0, 0 ) ),
        "TimePriod",
            FORMAT ( [Value], "hh:mm" ) & " - "
                & FORMAT ( [Value] + TIME ( 1, 0, 0 ), "hh:mm" )
    ),
    "TimePriod", [TimePriod]
)