Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JimB-GA
Helper III
Helper III

Creating an index column

Hello BI community,

 

I have an Excel file I am loading into BI that lacks a unique identifier.  I would like to create an index column.

 

Following is an example of the Excel file:

 

Date	Description
3/29/2019	PRUDENTIAL ABSOLUTE RETURN BOND FUND CLASS A
3/29/2019	TEMPLETON GLOBAL INCOME FUND
3/29/2019	BLACKROCK CORE BOND TRUST
3/28/2019	ALPHACENTRIC INCOME OPPORTUNITIES FUND CLASS A
3/27/2019	PROSHARES TR ULTRASHORT 20+ YR TREAS NEW
3/27/2019	NUVEEN ENHANCED MUNICIPAL VALUE FD
3/27/2019	PROSPECT CAPITAL CORPORATION
3/27/2019	BLACKROCK CORE BOND TRUST
3/27/2019	AMG FQ US EQUITY FUND CLASS N
3/26/2019	OPPENHEIMER ROCHESTER HIGH YIELD MUNICIPAL FUND CLASS A
3/26/2019	ISHARES TR RUSSELL 2000 ETF
3/25/2019	VanTar2025
3/25/2019	VanTar2025
3/22/2019	SELECT SECTOR SPDR TR FINANCIAL

I would like a sequential index column in the Power BI table.

 

I appreciate your assistance.

 

Regards

 

JimB-Ga

1 ACCEPTED SOLUTION
adityavighne
Continued Contributor
Continued Contributor

create new column in the


@JimB-GA wrote:

Hello BI community,

 

I have an Excel file I am loading into BI that lacks a unique identifier.  I would like to create an index column.

 

Following is an example of the Excel file:

 

Date	Description
3/29/2019	PRUDENTIAL ABSOLUTE RETURN BOND FUND CLASS A
3/29/2019	TEMPLETON GLOBAL INCOME FUND
3/29/2019	BLACKROCK CORE BOND TRUST
3/28/2019	ALPHACENTRIC INCOME OPPORTUNITIES FUND CLASS A
3/27/2019	PROSHARES TR ULTRASHORT 20+ YR TREAS NEW
3/27/2019	NUVEEN ENHANCED MUNICIPAL VALUE FD
3/27/2019	PROSPECT CAPITAL CORPORATION
3/27/2019	BLACKROCK CORE BOND TRUST
3/27/2019	AMG FQ US EQUITY FUND CLASS N
3/26/2019	OPPENHEIMER ROCHESTER HIGH YIELD MUNICIPAL FUND CLASS A
3/26/2019	ISHARES TR RUSSELL 2000 ETF
3/25/2019	VanTar2025
3/25/2019	VanTar2025
3/22/2019	SELECT SECTOR SPDR TR FINANCIAL

I would like a sequential index column in the Power BI table.

 

I appreciate your assistance.

 

Regards

 

JimB-Ga



@JimB-GA wrote:

Hello BI community,

 

I have an Excel file I am loading into BI that lacks a unique identifier.  I would like to create an index column.

 

Following is an example of the Excel file:

 

Date	Description
3/29/2019	PRUDENTIAL ABSOLUTE RETURN BOND FUND CLASS A
3/29/2019	TEMPLETON GLOBAL INCOME FUND
3/29/2019	BLACKROCK CORE BOND TRUST
3/28/2019	ALPHACENTRIC INCOME OPPORTUNITIES FUND CLASS A
3/27/2019	PROSHARES TR ULTRASHORT 20+ YR TREAS NEW
3/27/2019	NUVEEN ENHANCED MUNICIPAL VALUE FD
3/27/2019	PROSPECT CAPITAL CORPORATION
3/27/2019	BLACKROCK CORE BOND TRUST
3/27/2019	AMG FQ US EQUITY FUND CLASS N
3/26/2019	OPPENHEIMER ROCHESTER HIGH YIELD MUNICIPAL FUND CLASS A
3/26/2019	ISHARES TR RUSSELL 2000 ETF
3/25/2019	VanTar2025
3/25/2019	VanTar2025
3/22/2019	SELECT SECTOR SPDR TR FINANCIAL

I would like a sequential index column in the Power BI table.

 

I appreciate your assistance.

 

Regards

 

JimB-Ga




same table with below DAX

 

generate = GENERATESERIES(1,100,1)

View solution in original post

4 REPLIES 4
adityavighne
Continued Contributor
Continued Contributor

create new column in the


@JimB-GA wrote:

Hello BI community,

 

I have an Excel file I am loading into BI that lacks a unique identifier.  I would like to create an index column.

 

Following is an example of the Excel file:

 

Date	Description
3/29/2019	PRUDENTIAL ABSOLUTE RETURN BOND FUND CLASS A
3/29/2019	TEMPLETON GLOBAL INCOME FUND
3/29/2019	BLACKROCK CORE BOND TRUST
3/28/2019	ALPHACENTRIC INCOME OPPORTUNITIES FUND CLASS A
3/27/2019	PROSHARES TR ULTRASHORT 20+ YR TREAS NEW
3/27/2019	NUVEEN ENHANCED MUNICIPAL VALUE FD
3/27/2019	PROSPECT CAPITAL CORPORATION
3/27/2019	BLACKROCK CORE BOND TRUST
3/27/2019	AMG FQ US EQUITY FUND CLASS N
3/26/2019	OPPENHEIMER ROCHESTER HIGH YIELD MUNICIPAL FUND CLASS A
3/26/2019	ISHARES TR RUSSELL 2000 ETF
3/25/2019	VanTar2025
3/25/2019	VanTar2025
3/22/2019	SELECT SECTOR SPDR TR FINANCIAL

I would like a sequential index column in the Power BI table.

 

I appreciate your assistance.

 

Regards

 

JimB-Ga



@JimB-GA wrote:

Hello BI community,

 

I have an Excel file I am loading into BI that lacks a unique identifier.  I would like to create an index column.

 

Following is an example of the Excel file:

 

Date	Description
3/29/2019	PRUDENTIAL ABSOLUTE RETURN BOND FUND CLASS A
3/29/2019	TEMPLETON GLOBAL INCOME FUND
3/29/2019	BLACKROCK CORE BOND TRUST
3/28/2019	ALPHACENTRIC INCOME OPPORTUNITIES FUND CLASS A
3/27/2019	PROSHARES TR ULTRASHORT 20+ YR TREAS NEW
3/27/2019	NUVEEN ENHANCED MUNICIPAL VALUE FD
3/27/2019	PROSPECT CAPITAL CORPORATION
3/27/2019	BLACKROCK CORE BOND TRUST
3/27/2019	AMG FQ US EQUITY FUND CLASS N
3/26/2019	OPPENHEIMER ROCHESTER HIGH YIELD MUNICIPAL FUND CLASS A
3/26/2019	ISHARES TR RUSSELL 2000 ETF
3/25/2019	VanTar2025
3/25/2019	VanTar2025
3/22/2019	SELECT SECTOR SPDR TR FINANCIAL

I would like a sequential index column in the Power BI table.

 

I appreciate your assistance.

 

Regards

 

JimB-Ga




same table with below DAX

 

generate = GENERATESERIES(1,100,1)

Thanks.  I tried this and received the following error message:

 

A table of multiple values was supplied where a single value was expected.

adityavighne
Continued Contributor
Continued Contributor

Ok...just follow below adding Index column in the query editor.

 

Capture.PNG

 

AlB
Super User
Super User

Hi @JimB-GA 

You can do that easily in the query editor. Go to Add Column --> Add index column  

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors