Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.