Forum Discussion
Solved
Return a single value from a variable table in DAX by column name
How can I return the desc column value from this variable table? my_desc = VAR my_table = TOPN(1, DESC_TABLE) return my_table[DESC] Where DESC is a column in DESC_TABLE. This is a simplif...
Hi vfx661 ,
Here's the measure returns the result based on your scenario.
my_desc = VAR my_table = TOPN(1,'DESC_TABLE') return MAXX(my_table,[DESC])In addition to MAXX, MINX, if it is a numeric column, you can also use SUMX.
Also you can use summarize to return the single column.
my_desc = VAR my_table = TOPN(1,'DESC_TABLE') return SUMMARIZE(my_table,[DESC])Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi vfx661 ,
Here's the measure returns the result based on your scenario.
my_desc =
VAR my_table = TOPN(1,'DESC_TABLE')
return MAXX(my_table,[DESC])
In addition to MAXX, MINX, if it is a numeric column, you can also use SUMX.
Also you can use summarize to return the single column.
my_desc =
VAR my_table = TOPN(1,'DESC_TABLE')
return SUMMARIZE(my_table,[DESC])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.