Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
In the Query Editor, you need to insert this M code
{Number.From([Start])..Number.From([End])}
Hope this helps.
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"
Hi,
In the Query Editor, you need to insert this M code
{Number.From([Start])..Number.From([End])}
Hope this helps.
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"
I created a custom column with
{Number.From([Start])..Number.From([End])}
then i expanded the custom column
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |