Forum Discussion
Solved
table variable
I am trying to use the output of a LINESTX function in a DAX formula. When I try to access the Slope1 value from a table variable, the field is not found. Although if I create a calculated table using LINESTX, I am able to access the Slope1 value.
2 attempts at measure calling linestx variable both w/ error
calculated table definition w/out error
measure calling table w/out error
You just need:
SELECTCOLUMNS( linVar, [Slope1] )
It works referencing the variable but the intellisense can't pick it up at the moment. Just ignore the red underline.
1 Reply
You just need:
SELECTCOLUMNS( linVar, [Slope1] )
It works referencing the variable but the intellisense can't pick it up at the moment. Just ignore the red underline.