cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Column Start Date and End Date in list

Hi guys,

i'm trying to convert this:

 Base.PNG

 

in this:

New Base.PNG

 

Is that possible?

 

Tks!!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi,

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

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Solution Sage
Solution Sage

Hi @Williamspsouza 
Try using Datesbetween function.

 

Super User III
Super User III

Hi,

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

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

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"

 

Super User I
Super User I

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"

Capture.JPG


New Animated Dashboard: Sales Calendar


I created a custom column with 

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

 then i expanded the custom column

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors