VLOOKUP from seperate table

[Shelley-Baynton]

Hello,

I need to add additional columns to MainTable to add FYDetails for the four columns shown below. If it was in excel I'd do a vlookup to pull the details through. I'm not sure what the best approach would be to merge the tables or to use relatedtable function or something different.

MainTable

FiscalCalTable

Many thanks in advance 😃

[Anonymous · Accepted solution]

Hi @Shelley-Baynton ,

Please try the LOOKUPVALUE function.

For example,

MainTable

FiscalCalTable

There's no relationship between tabls. Create a calculated column in MainTable.

Column = LOOKUPVALUE('FiscalCalTable'[String],FiscalCalTable[Date],'MainTable'[Date])

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.