Lookup the date from another table

[birdie29]

Hello

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.

Once I can identify the budget transactions that occur after the latest reporting date I plan to create a measure that adds the actual values (From the 'Actual' table) up to latest reporting date to the remaining budget values, which will give me a full year view.

Am I going about this in the best way or am I missing a trick?

Any advice would be greatly received 🙂

Thank you

Chris

[v-caliao-msft · Accepted solution]

Hi @birdie29,

Lookupvalue returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…) 

Please provid us the details table structure of your tables and some sample data of them, so that we can make furhter analysis.

Regards,

Charlie Liao

[birdie29]

Hi @v-caliao-msft

Thank you for your quick reply! I had a complete memory block, apoliges I should have known this.

Thank you

Chris