Need help making a calendar that autofills days between two dates

[zecaben]

Video showing the current excel that you have to manually mark the dates:

https://drive.google.com/file/d/1e2JHw3eA1Pcq9lwUCD9bGXR1DwC3ctO8/view?usp=sharing

If someone can help me to automate this process in power bi while still loading the data in excel.

Thank you.

[Anonymous]

Create the datetable in Power Query and it can be loaded into both power BI and excel. If you want just the date paste this code into the advanced editor and edit the two dates to fit your desires

let
 
    FromDate=#date(2020,1,1),
    ToDate=#date(2025,12,31),
    Source=List.Dates(
        FromDate,
        Duration.Days(ToDate-FromDate)+1,
        #duration(1,0,0,0)
    ),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}})
in  #"Renamed Columns"