Forum Discussion
bml123
Post Patron
Post PatronHow to call a column from calculated var table
HI, I am using a calculated var table in a measure and need to call a column from a calculated var table to do some calculation. How do I do that?
Hi bml123 ,
You will need to define a name for this calculated column.
For example:
var table = selectedcolumns('table',"columnname",[column])
orvar table = addcolumns('table',"columnname",[column])
or
var table = SUMMARIZE ('table', [groupBy_columnName], "columnname", [column])
In above cases you could directly call the columnname.
Best Regards,
Jay
Hi bml123 ,
You will need to define a name for this calculated column.
For example:
var table = selectedcolumns('table',"columnname",[column])
or
var table = addcolumns('table',"columnname",[column])
or
var table = SUMMARIZE ('table', [groupBy_columnName], "columnname", [column])
In above cases you could directly call the columnname.
Best Regards,
Jay