Create custom column with a range of number

[Lovebo95]

Hi,

I want to create a custom column in my table with a range of number like : 1;2;3;4;5;...;20

And if I have more than 20 records in my table it will add in my column a 0 or null value.

Thank you,

Regards,

Lovebo

[Greg_Deckler]

RANDBETWEEN??

[amitchandak]

@Lovebo95 , You can create table generateseries

using https://docs.microsoft.com/en-us/dax/generateseries-function

You can additional column as per need

Also refer

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[Lovebo95]

Hi,

Generateseries() works good to create a new table, but to create a column in a table, it's always showing : 'A table of multiple values was supplied where a single value was expected'

Thanks for your help,

[az38]

@Lovebo95 

If I understand you correct:

1. Create an Index column started from 1 in Power Query Editor mode

2. In Report mode create a column like

ID = If(Table[Index] > 20, "null", Table[Index])

[az38]

@Lovebo95 

give an example please

[Lovebo95]

These are my table :

Name	Value
Jean	42
Mike	24
Paul	22
Sara	45
Bill	14

And i would like to have something like with using something like generateseries(1;3;1) or directly by hand like {1;2;3}

Name	Value	ID
Jean	42	1
Mike	24	2
Paul	22	3
Sara	45	null
Bill	14	null

Is it clear ?

Thank you,

[amitchandak · Accepted solution]

@Lovebo95 ,

did not get it now. Are you looking for an index column? What is the logic behind 1,2,3 null

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

[Lovebo95]

Thank you,

That's work for my issue, but in fact I would like to know if it's possible to add some data in a column as we can add some data in a new table with the functionnality : 'Enter data'.

🙂

[az38]

@Lovebo95 

with enter data you can only add data manually without any formulas

to add column with logic you can use Query Editor Add columns functionality or DAX