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 ,

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.