Forum Discussion
Creating a table for Minutes and Seconds - Looping
Hey, not sure if it's easier in DAX or M to do this but looking to create a list of Minutes and Seconds in the below format:
| Second | Minute |
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 1 | 2 |
| 2 | 2 |
| 3 | 2 |
| 4 | 2 |
| 5 | 2 |
Except I want the seconds to run from 1-60 instead of 1-5 and Minutes to run all the way to 90 minutes.
Is there a quick way to do this rather than appending lots of queries together or (gasp) doing it in Excel then copying over?
Thanks,
Rob
V quickly found a solution...
Created a DAX table with GENERATESERIES with the StartValue being any time - TIME(12,00,00) and the EndValue being 1.5 hours after this (to get my 90 mins) and with th increment value being 1 second (TIME(00,00,01)
Then Created a calculated column to get me the minutes, where I chose DATEDIFF from the minimum of the time column (created from the above calc table) and the time column to get me 0-90 mins. Then simply created a "SECOND" column to get me the Seconds from the Time column
2 Replies
V quickly found a solution...
Created a DAX table with GENERATESERIES with the StartValue being any time - TIME(12,00,00) and the EndValue being 1.5 hours after this (to get my 90 mins) and with th increment value being 1 second (TIME(00,00,01)
Then Created a calculated column to get me the minutes, where I chose DATEDIFF from the minimum of the time column (created from the above calc table) and the time column to get me 0-90 mins. Then simply created a "SECOND" column to get me the Seconds from the Time column
Anonymous,
By the way, you may help accept solution. Your contribution is highly appreciated.
