https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-rows-for-each-second-between-an-interval-start-and-end-time/m-p/1453066#M3403 <P>Create lists on the fly.</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="cpp">let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fdBLCsMwDEXRrQSPQ6JvYmsPgc5N9r+NWlSzCs0M1xzBm7NB2xsB9AMOHeuNcOI4CQg2BMNujNvn+Q8jwrvPhqVBYnxlBmkEN6g0eF2EzGCM4AbXxjo3UuOK4IaUhqCJZoZQBDe0Nm7TdFPpEdy4SkPZNN1UJYIbd22srz011PS3x/sF", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Index = _t, Build = _t, StartDate = _t, EndDate = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"StartDate", type datetime}, {"EndDate", type datetime}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Difference", each {0..Duration.TotalSeconds([EndDate]-[StartDate])}), #"Expanded Difference" = Table.ExpandListColumn(#"Added Custom", "Difference"), #"Added Custom1" = Table.AddColumn(#"Expanded Difference", "Custom", each [StartDate]+#duration(0,0,0,[Difference])) in #"Added Custom1"</LI-CODE> <P>&nbsp;</P> Sat, 24 Oct 2020 02:26:24 GMT lbendlin 2020-10-24T02:26:24Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-rows-for-each-second-between-an-interval-start-and-end-time/m-p/1447726#M3400 <P>&nbsp;<img /></P><P>How can i add in new rows for every second between these intervals?</P> Wed, 21 Oct 2020 18:51:35 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-rows-for-each-second-between-an-interval-start-and-end-time/m-p/1447726#M3400 asganesh 2020-10-21T18:51:35Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-rows-for-each-second-between-an-interval-start-and-end-time/m-p/1453066#M3403 <P>Create lists on the fly.</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="cpp">let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fdBLCsMwDEXRrQSPQ6JvYmsPgc5N9r+NWlSzCs0M1xzBm7NB2xsB9AMOHeuNcOI4CQg2BMNujNvn+Q8jwrvPhqVBYnxlBmkEN6g0eF2EzGCM4AbXxjo3UuOK4IaUhqCJZoZQBDe0Nm7TdFPpEdy4SkPZNN1UJYIbd22srz011PS3x/sF", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Index = _t, Build = _t, StartDate = _t, EndDate = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"StartDate", type datetime}, {"EndDate", type datetime}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Difference", each {0..Duration.TotalSeconds([EndDate]-[StartDate])}), #"Expanded Difference" = Table.ExpandListColumn(#"Added Custom", "Difference"), #"Added Custom1" = Table.AddColumn(#"Expanded Difference", "Custom", each [StartDate]+#duration(0,0,0,[Difference])) in #"Added Custom1"</LI-CODE> <P>&nbsp;</P> Sat, 24 Oct 2020 02:26:24 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-rows-for-each-second-between-an-interval-start-and-end-time/m-p/1453066#M3403 lbendlin 2020-10-24T02:26:24Z