Addition assignment operator formula in Power BI

[s15]

Hi guys,

I need to create a column that uses Addition assignment operator starting at "1999". I need to create such a column with 16 row (from 1999 - 2014). Does Power BI Formula support such a case? If not, can I just separate by a comma? (e.g = 1999, 2000,....)

For example:

x = 1999  
x += 1

[MarcelBeug · Accepted solution]

Not sure if you are looking for DAX or Power Query.

In Power Query you can create a table from scratch or you can add a custom index column starting at 1999 with increments of 1.

I did both, resulting in the following code. The first line was added via the advanced editor; the second line was generated by choosing Add Column - Index Column - Custom:

let
    Source = Table.FromColumns({{1999..2014}},type table[FromScratch = Int64.Type]),
    #"Added Index" = Table.AddIndexColumn(Source, "AddedAsCustomIndex", 1999, 1)
in
    #"Added Index"

[nickchobotar]

Hi  @MarcelBeug

 I see you are creating a nested list with double curly brackets and Table.FromColumns will not work with single set of curly brackets.

Does it mean that wrapping lists in another set of curly brackets allows PQ functions to recognize values as "official" columns ?

{{1999..2014}}

Thanks, N

[MarcelBeug]

Not exactly.

Wrapping a list like {1999..2014} in another set of curly brackets, creates a list with nested lists.

Suppose you would have
List1999_2014 = {1999..2014}

then you can create a list of lists with
DuplicateList = (List1999_2014,List1999_2014}

no need for inner curly brackets, as List1999_2014 is already a list.

This would be equivalent with:

DuplicateList = ({1999..2014},{1999..2014}}

Function Table.FromColumns requires a list of lists: each nested list will be a table column.

So Table.FromColumns(DuplicateList) would create a table with 2 columns.

I would formulate it as follows:

the function Table.FromColumns recognizes DuplicateList as a list of lists and creates a table with "official" columns.

[s15]

Thank you @MarcelBeug That works!