Convert Dax to M Code

[saddlerkayla]

I am trying to convert this DAX to M Code. I created a custom column with this DAX in the table view but I want to create this column in the Power Query editor. Please help!

Unique Product =

VAR CurrentProduct = 'Product Catalog'[Product Name]

VAR CurrentID = 'Product Catalog'[Index]

VAR Ranking =

    COUNTROWS(

        FILTER(

            'Product Catalog',

            'Product Catalog'[Product Name] = CurrentProduct

&& 'Product Catalog'[Index] <= CurrentID 

        )

    )

RETURN

    IF(

        Ranking > 1,

        CurrentProduct & " " & Ranking,

        CurrentProduct

[v-tsaipranay]

Hi @saddlerkayla ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

[v-tsaipranay]

Hi @saddlerkayla ,

Thanks for reaching out to the Microsoft fabric community forum. Thank you @jgeddes  for your helpful response.

Could you please confirm if your issue got resolved? For any further discussions or questions, please reach out to fabric community forum.

Thank you.

[saddlerkayla]

Thank you!

[jgeddes]

Consider example data...

You can get this result with the following code...

= Table.AddColumn(YourPreviousStep, "Unique Product", each let ranking = Table.RowCount(Table.SelectRows(YourPreviousStep, (r)=> [Product Name] = r[Product Name] and [Index] <= r[Index])) in if ranking > 1 then [Product Name] & " " & Number.ToText(ranking) else [Product Name], type text)

This should get you pointed in the right direction.