DAX Expression for lookupvalue in same table

[Anonymous]

Hi 

need experts your support for DAX expressions for the below table? I would like to bring the below values to the below cells or new columns 

[Fowmy · Accepted solution]

@Anonymous 

Please find below the solution in Power Query. File attached.

[Anonymous · Accepted solution]

Hi, really appreciate your file. but, I need to know how this is done. I can't use the file you provided. i am not sure how you did merge queries.

[Fowmy · Accepted solution]

@Anonymous 

Please find below the solution in Power Query. File attached.

[Anonymous · Accepted solution]

Hi, really appreciate your file. but, I need to know how this is done. I can't use the file you provided. i am not sure how you did merge queries.

[Fowmy]

I merged the same query as source and destination. You choose in the merge window. 

[Anonymous · Accepted solution]

ignore my message. I am able to find how you did it 😊. thank you for your support.