Quite interesting. I'd like to see how you pull the lookup from a different date row based on a value in a given record. Are you pulling this based on a column value = 'x' or relative rows?
One reference I have from another tool is using the DAX expression lookupvalue()
LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_
A sample using 4 columns for a compound key is...
=LOOKUPVALUE(Snapshot[FORECAST],Snapshot[Snapshot_Key],[PROJECT_ID] & [FIN_PERIOD] & [COST_TYPE] & date(year(today()),month(today())-1,1))
Hi Phil, in this very simple suggestion, all it does is look back one cell and return that value.
Sent from my iPhone
Thank you for the assistance Rob. From this and other posts it looks like I need to wait for new features. Until then the solution may be with SQL on the database side.