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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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 May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!