Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.