Creating a unique values Table

[DanC]

Hi, I'm new to Power BI, I am looking to create a unique numbering table which starts at 1 and will go all the way through to over 80,000 values (rows).

 i recently setup a number of tables in excel and just imported the data, however i am now looking to clear the source to all my excel tables and build the tables directly within Power BI.

Is there a way i can create a table that automatically builds the rows starting and number 1 and subsequently increases by one, going all the way to over 80,000?

I cannot copy  & Paste the data from the spreadsheet as it says "Clipboard contents are too large" and i cannot seem to just copy the data from existing table to create a new static table

Can anyone help or know of a DAX expression that creates the formula formual for me? perhaps a bit like the 'CALENDAR' DAX function but with values?

Thanks in advance

Dan

[Anonymous · Accepted solution]

Hi @DanC

Is this what you are looking for?
Create a new table ->

TableName = GENERATESERIES ( 1; 80000)

[DanC]

That works perfectly,

thankyou for your help

Regards

Dan