Try to translate DAX calculated column to PowerQuery M language

[FabianB]

Hi,
I have the following calculated column in the table afas_projecten which is connected to the table afas_nacalculatie with a one-to-many relationship.

DAX =

IF (

    CALCULATE (

        COUNTROWS ( afas_nacalculatie ),

        afas_nacalculatie[ItemCode] IN { "PROJ-AW", "PROJ-SMA", "PROJ-CAS" }

    )

        > 0,

    1,

    0

)

I am trying to make the same column in PowerQuery editor using M language.

My code now is this:

if List.ContainsAny(
Table.Column(Table.Join(afas_projecten, "ProjectId", afas_nacalculatie, "projectId", JoinKind.LeftOuter)[itemCode], "itemCode"),
{ "PROJ-AW", "PROJ-SMA", "PROJ-CAS" },
(a, b) => a = b
)
then 1
else 0

Unfortunately it is resulting in the following error:
Expression.Error: A cyclic reference was encountered during evaluation.

[lbendlin]

You're on the right track, likely just using a wrong reference.  

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...