Filter data table on most recent time stamp

[michielsoede]

Hi all,

I have a table with financial transactions and also different timestamps. What I would like to accomplish is the following:

- with cube values retrieve the latest financial forecast in Excel

ideally by creating a new virtual table that filters on the business unit and forecast version, determines the most recent timestamp and use that to retrieve the latest values.

Would creating such a virtual table be possible?

many thanks for your thoughts,

Michiel

[rwfigtree]

/////Calculated Column

IsLastestTimeStamp =
Var MaxTimeStamp=max(transactions[timestamp))
return if(transaction[timestamp]=MaxTimeStamp,true(),False())