cancel
Showing results for
Did you mean:
Resolver I

## 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I

## 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.

4 REPLIES 4
Super User I

Resolver I

## 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!!

Highlighted
Super User I

## 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.

Resolver I

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

It worked after some ajusts but help a lot.

Cheers,

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors