- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Create a column based on a number (DAX)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-02-2018 10:44 AM
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
Solved! Go to Solution.
Accepted Solutions
Re: Create a column based on a number (DAX)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-03-2018 07:03 AM
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
Re: Create a column based on a number (DAX)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-02-2018 11:36 AM
Show us your code using GENERATESERIES, please
Re: Create a column based on a number (DAX)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-03-2018 05:14 AM
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!!
Re: Create a column based on a number (DAX)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-03-2018 07:03 AM
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.
Re: Create a column based on a number (DAX)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-03-2018 01:07 PM
Thanks for the Reply!
It worked after some ajusts but help a lot.
Cheers,