Desktop

[diogoblunck]

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.

Very Thanks in advance

[HotChilli · Accepted solution]

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.

[HotChilli]

Show us your code using GENERATESERIES, please

[diogoblunck]

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

[HotChilli · Accepted solution]

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.

[diogoblunck]

Thanks for the Reply!

It worked after some ajusts but help a lot.

Cheers,