Forum Discussion

bml123's avatar
bml123
Icon for Post Patron rankPost Patron
4 years ago
Solved

How 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?
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

bml123 , Not very clear, refer to example

 

measure  =

var _tab = summarize(Table, Table[Employee], "_1", [M1])

return

Countx(Values(_tab), [Employee])