Forum Discussion

hoze's avatar
hoze
New Member
8 years ago
Solved

Looping through date range as parameters to web page to generate appended table

Hello,

I have set out to try to automate an appended table generated from tables invoked from parameterized dates in the web page, but creating a loop has been beyond my ability as someone just getting acquianted with power query. 

 

I've manually been able to generate an appended table such as:

(parameters corresponding to start and end date)

 

let
Source = Table.Combine({Date("01-01", "01-01"),Date("01-02", "01-02")})
in
Source

 

But I would really appreciate a query that could 'loop', via list.accumulate perhaps, a list of dates, where the return is an appended table that includes data of each day from the start of the year.

 

Thanks!

Need Help

2 Replies

  • hoze's avatar
    hoze
    New Member
    8 years ago

    I have managed to generate a list of the days from the start of the year:

     

    let
    Source = GetDaysList(#date(2018, 1, 1), Duration.Days(DateTime.Date(DateTime.FixedLocalNow())-#date(2018,1,1)), #duration(1, 0, 0, 0)),
    ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    MonthDay = Table.AddColumn(ToTable, "Day", each
    Text.PadStart(Number.ToText(Date.Month([Column1])),2,"0")
    &"-"&
    Text.PadStart(Number.ToText(Date.Day([Column1])),2,"0")),
    DeleteColumn = Table.RemoveColumns(MonthDay,{"Column1"}),
    TableList = Table.ToList (DeleteColumn)
    in
    TableList

     

    My problem of using the list as an input to a 'looping' table-appending query (i.e. list accumulate) remains...