Lookupvalue only for latest data

[ayordeky]

Hello,

An urgent question and any help appreciated
I am working with a model which uses two tables.
The first one is historical (there is column Updated Date)and is updated every week. So lets say it is my fact table where I have many lookupvalue columns to look data from my other dimension table.
Dimension table is not historic and is just updated every time. Now what I want to do is make my dimension table historic as well but transform my all functions in fact table so to look data not from entire dimension table but only from part of it. So I want to add a column as I have in the other table Updated Date and somehow filter within lookupvalue formulas to not use the entire table because then it is just duplicate values but just use the ones for which column Updated Date is today.

Any ideas how can I do this?
P.S
I am new to PowerPivot and maybe there is another way to do so.

 

[Useful]

Hello,
with lookupvalue() function? smt. like this?

=LOOKUPVALUE(Table1[Result],Table1[Date_Column],today(),Table1[Search_Column_Name],[Search_Value])

 

[ayordeky]

Many thanks. Yes exactly as simple as it is )