Forum Discussion
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
2 Replies
- amitchandak
Super User
bml123 , Not very clear, refer to example
measure =
var _tab = summarize(Table, Table[Employee], "_1", [M1])
return
Countx(Values(_tab), [Employee])
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
