The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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.
@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(<>))
)
Thankyou For your support Brother
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |