Excel Formula to Power BI

[tejapowerbi]

Hello,
How to write below excel formula into Power BI?
=IFERROR(AVERAGEIF('Historical '!$A$3:$X$100687,'Current Year '!$A2,'Historical '!$X$3:$X$100687),"No AUP ")
Thanks

 

[tejapowerbi]

Historical $A$3 is table,current year and Historical $x$3 are column.I am not sure do i need also need lookup as well.Thanks