Convert to 30min interval

[nchand]

Hello All,

I am trying to plot a line graph with two variables—time in 30min intervals on the x-axis and count of #ppl in that time frame.

How to convert this column to represent time in every 30min interval? Many thanks for considering my request. 

[NickolajJessen]

Here you go 🙂

[nchand]

Thanks for this solution. will use this if I cannot make it to this format below: (not sure how to aggregate to this model tho)

[NickolajJessen · Accepted solution]

You can make it easily:
1. Adjust the formulas to AM PM format

2. Create a table in power query with you categories and add index (make sure to filter cate category by the index)

3. Create relationship between the two tables
4. Voila

[nchand]

I have a doubt in this. When we say this

Table[Timestamp]<TIMEVALUE("08:00"), "8;00am"
Table[Timestamp]<TIMEVALUE("08:30"), "8;30am"

If I had a 06:30 in the Timestamp column. what will it be considered? 8 or 8;30am?  

[NickolajJessen]

That's a great questions!
it returns the first value that is TRUE

Table[Timestamp]<TIMEVALUE("08:00"), "8;00am" // This is true // AND THIS IS FIRST
Table[Timestamp]<TIMEVALUE("08:30"), "8;30am" // This also true, but is never evaluated, beause the first the first was true

---