Reply
Regular Visitor
Posts: 18
Registered: ‎10-02-2018
Accepted Solution

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.

 

Very Thanks in advance


Accepted Solutions
Highlighted
Member
Posts: 119
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.

View solution in original post


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

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

Show us your code using GENERATESERIES, please

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

Highlighted
Member
Posts: 119
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.

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

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

Thanks for the Reply!

 

It worked after some ajusts but help a lot.

 

Cheers,