Forum Discussion
Solved
Approximate Match to retrieve values from other table
Hi,
I have monthly KPIs achievements in one table updated on monthly basis in 'Table1'. I have separate table for Targets where he changes in targets are updated against each month in 'Table2'.
In excel, I was using XLOOKUP with approximate match to retrieve target from 'Table2" for each month in 'Table1". How can I do the same in Power BI. Please advise.
Table1
| Month | Achievements | Targets (Retreieved from Table2) |
| Jan-23 | 82% | 80% |
| Feb-23 | 78% | 80% |
| Mar-23 | 88% | 85% |
| Apr-23 | 69% | 85% |
| May-23 | 73% | 85% |
Table2
| Month | Targets |
| Jun-20 | 80% |
| Mar-23 | 85% |
5 Replies
- ThxAlot
Super User
Thanks, it worked very smoothly :).
- Idrissshatila
Hello firasath ,
you use the following formula
Target from table 2 = LOOKUPVALUE('Table 2'[Target],'Table 2'[Month],'Table 1'[Month]) Thanks Idrissshatila , but the above solution I tried earlier and the result is it is only updating the target for the month when the change happened, like illustrated in below table. It is not updating for all month. All other months are remanining blank in new column.
Month Achievements Targets (Retreieved from Table2) Jan-23 82% Feb-23 78%
Mar-23 88% 85% Apr-23 69% May-23 73% - Idrissshatila
