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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
faiqsadiq1
Frequent Visitor

Specific dates to Enter in Calendar

calendar date.pngcalendar date 2.pngcalendar date 3.png

 

 

 

HI i hope you would be all fine.There is an issue that there is some data that has dates 01 jan 1900,11 nov 2222.
I want these two dates to be part of my calendar table .

Can they be added please so i can see these two dates data too or any other way ?

I am not convinced to make a calendar too long for this scenario.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @faiqsadiq1 ,

Are you saying that the calendar table mainly contains 2019/1/1 and 2222/11/11? 

let
    Source = Query1(#date(2019, 1, 1), 20, #duration(30, 0, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"New"=Table.InsertRows(#"Converted to Table",1,{[Column1=Date.FromText("2222-11-11")]}),
    #"Sorted Rows" = Table.Sort(New,{{"Column1", Order.Ascending}})
in
    #"Sorted Rows"

 

let
    Source = List.Dates(#date(2019, 1, 1), 20, #duration(30, 0, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"New"=Table.InsertRows(#"Converted to Table",1,{[Column1=Date.FromText("2222-11-11")]}),
    #"Sorted Rows" = Table.Sort(New,{{"Column1", Order.Ascending}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Sorted Rows",{{"Column1", type date}})
in
    #"Changed Type"

 

vpollymsft_0-1668567646905.png

 

If it still does not help, please provide more details with your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @faiqsadiq1 ,

Are you saying that the calendar table mainly contains 2019/1/1 and 2222/11/11? 

let
    Source = Query1(#date(2019, 1, 1), 20, #duration(30, 0, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"New"=Table.InsertRows(#"Converted to Table",1,{[Column1=Date.FromText("2222-11-11")]}),
    #"Sorted Rows" = Table.Sort(New,{{"Column1", Order.Ascending}})
in
    #"Sorted Rows"

 

let
    Source = List.Dates(#date(2019, 1, 1), 20, #duration(30, 0, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"New"=Table.InsertRows(#"Converted to Table",1,{[Column1=Date.FromText("2222-11-11")]}),
    #"Sorted Rows" = Table.Sort(New,{{"Column1", Order.Ascending}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Sorted Rows",{{"Column1", type date}})
in
    #"Changed Type"

 

vpollymsft_0-1668567646905.png

 

If it still does not help, please provide more details with your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@faiqsadiq1 , You can, but then you can not mark it as date table,

 

Create a table using

Union (calendar(date(<>) , Date(<>)) ,

row("Date", Date(<>) ) ,

row("Date", Date(<>))

)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thankyou For your support Brother

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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