Forum Discussion
Solved
Convert to 30min interval
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 ever...
You can make it easily:
1. Adjust the formulas to AM PM format2. 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
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?
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