Converting DAX to M, please help me about this

[Anonymous]

=
IF (
    order_details[PRODUCT_CATEGORY]  = "Trial",
    0,
    IF (
      order_details[PRODUCT_CATEGORY]  = "Trial Completion",
        1,
        IF (
            order_details[PRODUCT_CATEGORY] <> "Rebill",
            -5,
           
                RANKX (
                    FILTER (
                        order_details,
                        order_details[Unique_Key] = EARLIER ( order_details[Unique_Key] )
                            && RELATED ( products[PRODUCT_CATEGORY] ) = "Rebill"
                            && order_details[ORDER_STATUS] <> "DECLINED"
                            && order_details[IS_TEST_ACTUAL] = "N"
                    ),
                    order_details[order_id],
                    ,
                    ASC
                ) + 1,
                
            )
        )
    )
)

[v-easonf-msft]

Hi, @Anonymous 

For now, your dax formula involves two or more tables. In powerbi M query, you will most likely need to create a new query to associate the two tables(order_details and products). It is recommended to provide sample data for further research.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi,

lets say, this is from one table.

=
IF (
    order_details[PRODUCT_CATEGORY]  = "Trial",
    0,
    IF (
      order_details[PRODUCT_CATEGORY]  = "Trial Completion",
        1,
        IF (
            order_details[PRODUCT_CATEGORY] <> "Rebill",
            -5,
           
                RANKX (
                    FILTER (
                        order_details,
                        order_details[Unique_Key] = EARLIER ( order_details[Unique_Key] )
                            && order_details[PRODUCT_CATEGORY]  = "Rebill"
                            && order_details[ORDER_STATUS] <> "DECLINED"
                            && order_details[IS_TEST_ACTUAL] = "N"
                    ),
                    order_details[order_id],
                    ,
                    ASC
                ) + 1,
                
            )
        )
    )
)