Specific dates to Enter in Calendar

[faiqsadiq1]

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.

[Anonymous · Accepted solution]

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"

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]

@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(<>))

)

[faiqsadiq1]

Thankyou For your support Brother