Generating date table by year

Hi bleow,

Did you mean to use the current date and the range to generate a table with the start date and end date? 

If that is the case, you can take a look at the following formula:

let
    offset = 4,
    Source =
        List.Transform(
            List.Numbers(
                Date.Year(DateTime.LocalNow())
                - offset
                + 1,
                offset
            ),
            each
                Text.From(_)
                & ","
                & Text.From(#date(_, 1, 1))
                & ","
                & Text.From(#date(_, 12, 31))
        ),
    #"Converted to Table" =
        Table.FromList(
            Source,
            Splitter.SplitTextByDelimiter(","),
            null,
            null,
            ExtraValues.Error
        ),
    #"Renamed Columns" =
        Table.RenameColumns(
            #"Converted to Table",
            {
                {
                    "Column1",
                    "Year"
                },
                {
                    "Column2",
                    "Start"
                },
                {
                    "Column3",
                    "End"
                }
            }
        ),
    #"Changed Type" =
        Table.TransformColumnTypes(
            #"Renamed Columns",
            {
                {
                    "Year",
                    Int64.Type
                },
                {
                    "Start",
                    type date
                },
                {
                    "End",
                    type date
                }
            }
        )
in
    #"Changed Type"

Regards,
Xiaoxin Sheng