cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bsheffer
Helper V
Helper V

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'))

 

but when I use it in this clause it says it isn't a valid table

 

month('Dim Calendar ActivityMonth'[Date]) in _months_selected
 
what's the correct syntax?
1 ACCEPTED SOLUTION
jeroendekk
Resolver IV
Resolver IV

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

View solution in original post

1 REPLY 1
jeroendekk
Resolver IV
Resolver IV

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

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors