## Desktop

Regular Visitor
Posts: 18
Registered: ‎10-02-2018

# Create a column based on a number (DAX)

Hello Guys!

I need to create a column in DAX based in a number.

Sample:

Client     |  Number of Portions

Client 1  |  43

I need to create a column based in the Number of Portions.

What I need:

Number of Portions DAX

1

2

3

...

43

After this i will need to use that value of row to some financial equasions, like NPV.

I will use a filter of client to mainten just one client to the page.

I have tryed Summarize with Addcoluns without sucess, after tryed the GENERATESERIES but for some reason they dont make the column.

Accepted Solutions
Member
Posts: 124
Registered: ‎09-10-2018

## Re: Create a column based on a number (DAX)

I'm not sure I completely understand what you want..  but if you want to use GENERATESERIES,  the result is a table with one column of numbers.  If you have another table with a client name for example, you can build a 3rd table using GENERATE or CROSSJOIN.

Here's a small example

```TableNumbers = GENERATESERIES(1, 50,1)

TableClient = DATATABLE("Client", STRING, {{ "fred"}})

TableClientsNumbers = CROSSJOIN(TableClient ,  TableNumbers )```

This will produce a table with fred, 1    fred,2 and so on.

I think your scenario is more complex but this might get you started.

All Replies
Member
Posts: 124
Registered: ‎09-10-2018

## Re: Create a column based on a number (DAX)

Regular Visitor
Posts: 18
Registered: ‎10-02-2018

## Re: Create a column based on a number (DAX)

Hello @HotChilli

The code I used:

Measure = GENERATESERIES(1;AVERAGE(Contratos[Qtd. Parcelas]);1)

The AVERAGE(Contratos[Qtd. Parcelas]) bring me the number of Portions the Client Have.

I tryed to put this in a table using summarize:

Table = SUMMARIZE(Contratos;Contratos[Nº. Contrato];"Parcelas";[Measure])

Thax again!!

Member
Posts: 124
Registered: ‎09-10-2018

## Re: Create a column based on a number (DAX)

I'm not sure I completely understand what you want..  but if you want to use GENERATESERIES,  the result is a table with one column of numbers.  If you have another table with a client name for example, you can build a 3rd table using GENERATE or CROSSJOIN.

Here's a small example

```TableNumbers = GENERATESERIES(1, 50,1)

TableClient = DATATABLE("Client", STRING, {{ "fred"}})

TableClientsNumbers = CROSSJOIN(TableClient ,  TableNumbers )```

This will produce a table with fred, 1    fred,2 and so on.

I think your scenario is more complex but this might get you started.

Highlighted
Regular Visitor
Posts: 18
Registered: ‎10-02-2018