Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
zecaben
New Member

Need help making a calendar that autofills days between two dates

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.

1 REPLY 1
Corey_M
Resolver II
Resolver II

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"

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.