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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

add old dates to my Calendar query

Dear

i have build report and date start from start from 2020 in my caledar quesry, now i want to add 2019 dates, how i can add those dates to exiting caleddar query

 

BR

 

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

Create a blank query in the query editor and repace the code in the advance editor with this:

let
    Source = List.Dates(#date(2019, 1, 1), 365, #duration(1, 0, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
   #"Converted to Table"


Append the new calendar to your current one. 

/ J


Connect on LinkedIn

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User
Anonymous
Not applicable

HI i have already my caleddar strting from 2020

 

bu i need to add 2019 on top of exiting one, i do not want to break current one

 

looking for your help

 

thanx

tex628
Community Champion
Community Champion

Create a blank query in the query editor and repace the code in the advance editor with this:

let
    Source = List.Dates(#date(2019, 1, 1), 365, #duration(1, 0, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
   #"Converted to Table"


Append the new calendar to your current one. 

/ J


Connect on LinkedIn

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.