Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous,

 

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