Use table as variable

[robon]

When i want to use a table value as variable i get the error Expression.Error cannot use operator & with Text and Table(Sorry translated from Dutch)

this is the line of the error:

<SessionID>"& Session_ID() &"</SessionID>

what am i doing wrong?

Thanks 

Rob

[Anonymous]

Hi @robon ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you‌‌😀

Best Regards,
Eyelyn Qin

[robon]

Sorry Eyelyn,

it works thanx a lot

Rob

[Anonymous · Accepted solution]

Hi @robon ,

Sorry for that the information you have provided is not making the problem clear to me.

If you want to use the values in column as variables ,please use the following formula to create a calculated column or a measure:

Column = 
var columnVariable=[Session]
return [Session] &" - " & "Table1" 

Measure = 
var measureVariable=MAX('Table1'[Session])
return measureVariable &" - " & "Table1"

If it does not make sense, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

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