The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
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
Sorry Eyelyn,
it works thanx a lot
Rob
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.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |