Forum Discussion
Vlookup - Repleace Value
Hi Team,
I have below table and need to replace value based on matching column (MTC).
in below Data table replace (iTicket, iStatus) column based on below Pending table.
How do I replace.
Thanks,
Kali
Hi , Anonymous
As mentioned by Fowmy ,you can use "lookupvalue" as below:
Replace iStatus = LOOKUPVALUE('Pending Status'[iStatus],'Pending Status'[MTC],Data[MTC])Replace iTicket = LOOKUPVALUE('Pending Status'[iTicket],'Pending Status'[MTC],Data[MTC])For more details,please refer to the attached pbix file.
If you consider this issue closed, please mark it as "solved".
Best Regards,
Community Support Team _ Eason
2 Replies
- Fowmy
Super User
Anonymous
You use the LOOKUPVALUE function.
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
- v-easonf-msft
Community Support
Hi , Anonymous
As mentioned by Fowmy ,you can use "lookupvalue" as below:
Replace iStatus = LOOKUPVALUE('Pending Status'[iStatus],'Pending Status'[MTC],Data[MTC])Replace iTicket = LOOKUPVALUE('Pending Status'[iTicket],'Pending Status'[MTC],Data[MTC])For more details,please refer to the attached pbix file.
If you consider this issue closed, please mark it as "solved".
Best Regards,
Community Support Team _ Eason
