Approximate Match to retrieve values from other table

[firasath]

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%

[ThxAlot · Accepted solution]

[firasath]

Thanks, it worked very smoothly :). 

[firasath]

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]

@firasath ,

is there records for another months ?

[Idrissshatila]

Hello @firasath ,

you use the following formula

Target from table 2 = LOOKUPVALUE('Table 2'[Target],'Table 2'[Month],'Table 1'[Month])