Column Start Date and End Date in list

[Anonymous]

Hi guys,

i'm trying to convert this:

 

in this:

Is that possible?

Tks!!

[smpa01]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WClfSUTIw0wciIwNDSwjHyADCidWJVnIFCZnqAxFMHsixgMrHAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, Start = _t, End = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Start", type date}, {"End", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each {Number.From([Start])..Number.From([End])}),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Custom", type date}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Custom", "Date_Series"}})
in
    #"Renamed Columns"

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, you need to insert this M code

{Number.From([Start])..Number.From([End])}

Hope this helps.

[Anonymous]

I'm sorry but i'm not seeing how to use that in my code.

As a test i wrote this code to create a test table:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8so/vDhfSUfJwFDfwFTfyMDQEsQxhXNidaKVAlJTisBqTJDVmCPUxAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, Start = _t, End = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Start", type date}, {"End", type date}})
in
#"Changed Type"

[Anonymous]

I created a custom column with 

{Number.From([Start])..Number.From([End])}

 then i expanded the custom column

[Anonymous]

Hi @Anonymous 
Try using Datesbetween function.