Creating a table for Minutes and Seconds - Looping

[robstewart89]

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

[robstewart89 · Accepted solution]

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

[v-chuncz-msft]

@robstewart89,

By the way, you may help accept solution. Your contribution is highly appreciated.