new query from table

Would LOOKUPVALUE be the best function for this scenario?

Thanks again

**** SOLUTION UPDATE ****

It was not able to create New Query based on the generated New Table. So managed to solve with this function:

ColumNew = LOOKUPVALUE(tbl_Averages_as_tabular[Usage Forecasted],tbl_Averages_as_tabular[Works Type],tbl_Future_Allocations_Plannned[Works Type],tbl_Averages_as_tabular[Item],tbl_Future_Allocations_Plannned[Item])

Hi henrique0galli

This would be more efficient as a calculated column and I have attached a PBIX file to demonstrate

New Column = 
    MINX(
        FILTER(
            'tbl_Averages_as_tabular',
            'tbl_Averages_as_tabular'[Item] = EARLIER('tbl_Future_Allocations_Plannned'[Item]) &&
            'tbl_Averages_as_tabular'[Works Type] = "Btoc"
            ),
            [Usage Forecasted])