Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to use this variable in an IN statement in a calculate
var _months_selected = calculate(VALUES('Dim Calendar ActivityMonth'[MonthNo]), allselected('Dim Calendar ActivityMonth'))
but when I use it in this clause it says it isn't a valid table
Solved! Go to Solution.
Hi @bsheffer
If you want to create a table you should use CALCULATETABLE not CALCULATE.
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
Best regards,
Jeroen
Hi @bsheffer
If you want to create a table you should use CALCULATETABLE not CALCULATE.
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
Best regards,
Jeroen
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |