First Occurrence of Value as a Custom Column

[Anonymous]

What would be the equivalent of the following DAX in Power Query...I am trying to bring the First Occurence Check column info into another table but the relationship between table A and table B is many to many and the i have multiple occurance of the SO Order Number. I only want from Table A where the First Occurence Check is 1 in table B. 

I cannot measure the two table as its a calculated column in Table A.

First Occurence Check = if (calculate (COUNTROWS(NEWBI_COMPS),filter(ALLEXCEPT(NEWBI_COMPS,NEWBI_COMPS[SO]),NEWBI_COMPS[Index]<=earlier(NEWBI_COMPS[Index])))>1,0,1) 

[jennratten]

Without any details for your data it's difficult to help.  Have you tried any of the recommended solutions based on your question?  

[Anonymous · Accepted solution]

Hi - I Found a workable solution on line
https://blog.crossjoin.co.uk/2015/05/11/nested-calculations-in-power-query/