Forum Discussion

Mattias's avatar
Mattias
New Member
3 years ago
Solved

How to create a date column in a timetable

Hi.   I have a time table set up like this.   TimeTable = var HourTable = SELECTCOLUMNS(GENERATESERIES(0, 23), "Hour", [Value]) var MinuteTable = SELECTCOLUMNS(GENERATESERIES(0, 59), "Minute"...
  • ValtteriN's avatar
    ValtteriN
    3 years ago

    Hi Mattias,

    Here is one way to do this:

    TimeTable =
    var HourTable = SELECTCOLUMNS(GENERATESERIES(0, 23), "Hour", [Value])
    var MinuteTable = SELECTCOLUMNS(GENERATESERIES(0, 59), "Minute", [Value])
    var SecondsTable = SELECTCOLUMNS(GENERATESERIES(0, 59), "Second", [Value])
    return
    ADDCOLUMNS(
        CROSSJOIN(HourTable, MinuteTable, SecondsTable),
        "Time", TIME([Hour], [Minute], [Second]),
        "Date",TODAY(),
        "DateTime",FORMAT(TODAY() &" " & TIME([Hour], [Minute], [Second]),"DD/MM/YYYY HH:MM:SS"))

    End result:

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/



ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Mattias,

Here is one way to do this:

TimeTable =
var HourTable = SELECTCOLUMNS(GENERATESERIES(0, 23), "Hour", [Value])
var MinuteTable = SELECTCOLUMNS(GENERATESERIES(0, 59), "Minute", [Value])
var SecondsTable = SELECTCOLUMNS(GENERATESERIES(0, 59), "Second", [Value])
return
ADDCOLUMNS(
    CROSSJOIN(HourTable, MinuteTable, SecondsTable),
    "Time", TIME([Hour], [Minute], [Second]),
    "Date",TODAY(),
    "DateTime",FORMAT(TODAY() &" " & TIME([Hour], [Minute], [Second]),"DD/MM/YYYY HH:MM:SS"))

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/



  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It worked like a charm! And so simple when you look at it in retro spective, but i couldn't have done it without you, thank you so much