Forum Discussion

mdgene's avatar
mdgene
Icon for Helper I rankHelper I
4 years ago
Solved

Using Column name as a variable

Hi Please I am trying to pass column name as a variable to create a table.   This query is fine (Ii am using the column name explicitly) TestTable = var b = CALCULATETABLE( SELECTCOLUMNS('Hou...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, mdgene 

    Because in the following formula, the variable T is not recognized as a column in the table, but as a text. You cannot label a column in the variable way above.
    Therefore, in the filter function, the filtering condition is that text 1 is equal to text 2, not that the column value is equal to "b", so the result of the filter function is empty, and the returned table is empty.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, mdgene 

Because in the following formula, the variable T is not recognized as a column in the table, but as a text. You cannot label a column in the variable way above.
Therefore, in the filter function, the filtering condition is that text 1 is equal to text 2, not that the column value is equal to "b", so the result of the filter function is empty, and the returned table is empty.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.