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
