sandy666
02-19-2021, 01:37 AM
(question from the web (https://www.mrexcel.com/board/threads/number-from-in-powerbi.1162200/))
Could somebody please tell me what this line in the Applied Steps in PowerBI would be doing, it adds a column, and it looks like it takes a number from Date A, but I'm not sure what the double period between the two NumberFrom's does.
Table.AddColumn(#"Changed Type","Custom",each {NumberFrom([DateA])..Number.From([From([Dateb])})
imho this formula doesn't have a proper syntax but generally speaking this is a List
A list value is a value which produces a sequence of values when enumerated. A value produced by a list can contain any kind of value, including a list. Lists can be constructed using the initialization syntax, as follows:
{ 1, 5..9, 11 } // { 1, 5, 6, 7, 8, 9, 11 }
Could somebody please tell me what this line in the Applied Steps in PowerBI would be doing, it adds a column, and it looks like it takes a number from Date A, but I'm not sure what the double period between the two NumberFrom's does.
Table.AddColumn(#"Changed Type","Custom",each {NumberFrom([DateA])..Number.From([From([Dateb])})
imho this formula doesn't have a proper syntax but generally speaking this is a List
A list value is a value which produces a sequence of values when enumerated. A value produced by a list can contain any kind of value, including a list. Lists can be constructed using the initialization syntax, as follows:
{ 1, 5..9, 11 } // { 1, 5, 6, 7, 8, 9, 11 }