Forum Discussion

sebastian62460's avatar
sebastian62460
Copper Contributor
Sep 22, 2023

Excel power query custom column

Hello I have this formula in custom power query column. I want to make a list of times in a 5 minutes interval. The start is in [Zaciatok Procedury] column and the end is in [Koniec Procedruy]. For e...
developer
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 23, 2023

sebastian62460 

If count number of intervals as Duration.TotalMinutes( Duration.From( [End]-[Start] ) )/5+1 it works as well.

All together

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    addPeriods = Table.AddColumn(
        Source,
        "List",
        each List.Times(
            Time.From( [Start] ),
            Duration.TotalMinutes( Duration.From( [End]-[Start] ) )/5+1,
            #duration(0,0,5,0))),
    expandPeriods = Table.ExpandListColumn(addPeriods, "List")
in
    expandPeriods

Resources