Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm running into trouble trying to use SELECTEDVALUE on a column from a table variable.
See code below from calculated column, inside "Current Table"
Department Selected =
//Other defined variables here...
var temptable =
SELECTCOLUMNS(
FILTER(
'Table1',
'Table1'[CustomerID] = 'Current Table'[CustomerID]
&& 'Table1'[Start Date] <= variable1
&& 'Table1'[End Date] > variable2
&& 'Table1'[Urgency] = variable3
),
"Department",'Table1'[Department]
)
return
SELECTEDVALUE('temptable'[Department], "multiple departments")
My code of course fails on the return, as you can't seem to reference a column of a variable table in selectedvalue.
Is there an alterative way I can accomplish this?
I don't want to use CALCULATE, as it takes absolutely ages and I'm trying to find a workaround. I also need it to be a calculated column, so can't use a measure.
Thanks in advance!
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |