Transformation rate // Vlookup() // DAX

[LucienF38]

Dear all,

I have the following issue. I have in a power BI table named 'OOLINE' a column [ORNO-Customer Order Number]. In this column I have numbers of quotations and orders. The quotations are defined by a 10 digits number starting with '0060' and the orders are defined by a 10 digits number starting with '00007'. 

I have would like to calculate the rate of transformation of the quotes into orders. The issue is that each quotation can be used several times by the customer to give purcharse orders. Then, to have the rate of transformation I need to take only the earliest in date. 

I made it under excel using the following concatenate and VLOOKUP() with the two sheets "orders" and "quote":

How can I reach the same goal in PBI? I did a concatenate with the customer number // Item number // price but what are the following step ? 

Staying at your disposal for any question!

I really need help on this ... I have been working on this since the last week and can't find anything 😞 

Thanks in advance !!

[v-yuta-msft]

@LucienF38 ,

Could you please share some sample data and show the expected result?

Regards,

Jimmy Tao

[LucienF38]

Hi @v-yuta-msft ,

Here is the expected result. I would like to see the rate of transformed quotations into Order. In blue the transformed ones, in orange the non-transformed, in grey the commands that have been done before the quote, which are not interesting for me.