IN OPERATOR with Variable List

[LesNOS482]

NEWB alert. apologies in advance.

I'd like to filter my results based on a previously generated list, in this case the months included need to be limited to only those included in the list - here because the variable IN isn't working after 2 days of trying.

$perMD =

var POSTMONTHS = 
SUMMARIZE(FILTER(table, table[Report Window] = "Post"
&& table[xFilter] = "I"),
table[PRMONTHID])

return

CALCULATE(
DIVIDE(
table[$ Payments],
table[MDs]),
table[Report Window] = "Before",
FILTER(table, [PRMONTHID] IN (POSTMONTHS)))

many thanks

[v-xiaotang]

Hi @LesNOS482 

If you want to filter list by another list, the function that may be relevant is INTERSECT(<table_expression1>, <table_expression2>)

But this is just a guess, a more specific example is needed for confirmation.

usually information below is needed, could you provide it? Thanks.

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result and its math formula based on the sample you provide.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[davehus]

Hi @LesNOS482, Not really sure about your model structure but all reads as if it's from the same table of data. Could you create a calculated column to indicate the post months and then apply it as a filter context in the final calculation?