Lookup the date from another table

Question

Hello&nbsp;I have a table with Budget transactions called 'Budget' and I would like a column within the table to say 'Yes' if the budget transaction date is after the 'Latest Reporting Date', which is in the 'Time' table.&nbsp;Once I can identify the budget transactions that occur after the latest reporting date I&nbsp;plan to&nbsp;create a measure that adds the actual values (From the 'Actual' table) up to latest reporting date to the remaining budget values, which will&nbsp;give me a full year view.&nbsp;Am I going about this in the best way or am I missing a trick?&nbsp;Any advice would be greatly received :)&nbsp;Thank youChris

v-caliao-msft · Accepted Answer

Hi birdie29,
&nbsp;
Lookupvalue returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.LOOKUPVALUE( &lt;result_columnName&gt;, &lt;search_columnName&gt;, &lt;search_value&gt;[, &lt;search_columnName&gt;, &lt;search_value&gt;]…)&nbsp;
&nbsp;
Please provid us the details table structure of your tables and some sample data of them, so that we can make furhter analysis.
&nbsp;
Regards,
Charlie Liao
&nbsp;
&nbsp;

Forum Discussion

Lookup the date from another table

2 Replies

Related content

Power Query LookUp in another table

Lookup to another table?

lookup value in another table which matches value in another

Lookup values from another table

Lookup value from another table