Forum Discussion

bsheffer's avatar
bsheffer
Continued Contributor
4 years ago
Solved

why is this not a valid table

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'))   bu...
Need Help
  • jeroendekk's avatar
    jeroendekk
    4 years ago

    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

jeroendekk's avatar
jeroendekk
Responsive Resident
4 years ago

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