Filter data table on most recent time stamp

Anything related to PowerPivot and DAX Formuale
michielsoede
Posts: 1
Joined: Sun Jun 14, 2020 5:06 pm

Filter data table on most recent time stamp

Postby michielsoede » Sun Jun 14, 2020 5:17 pm

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

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest

cron