cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
amsrivas
Helper IV
Helper IV

How to capture single column value from table in Text

Hi Folks!!

I have a table with one column say Country and it has just one value (always) say INDIA, though the name name of the country can be changes but number of rows remains 1.

 

I just want to capture this value in Text variable in Power BI M Query.

 

Please suggest!!

Thanks

Amit 

2 ACCEPTED SOLUTIONS
HotChilli
Super User
Super User

You can use Table{0}[Column] to refer to it (use your table and column names).

You can put it in a variable with an assignment e.g.

p = TableA{0}[Column1]

View solution in original post

Hi @HotChilli ,

 

Thanks for your answer, it works well.

p = TableA{0}[Column1]

 

However, i too find some other way out to achieve the goal, below is the code.

varName=Table.FirstValue(TableName)

 

This will give first column of first row.

 

Thanks

Amit Srivastava

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

You can use Table{0}[Column] to refer to it (use your table and column names).

You can put it in a variable with an assignment e.g.

p = TableA{0}[Column1]

Hi @HotChilli ,

 

Thanks for your answer, it works well.

p = TableA{0}[Column1]

 

However, i too find some other way out to achieve the goal, below is the code.

varName=Table.FirstValue(TableName)

 

This will give first column of first row.

 

Thanks

Amit Srivastava

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors