cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diogoblunck Resolver I
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.

 

Very Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
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.

View solution in original post

4 REPLIES 4
Super User I
Super User I

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

Show us your code using GENERATESERIES, please

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

Super User I
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.

View solution in original post

Highlighted
diogoblunck Resolver I
Resolver I

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

Thanks for the Reply!

 

It worked after some ajusts but help a lot.

 

Cheers,

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘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