Filter Last Date in all Rows

Questions & Answers
, ,
1

Hi at All,
we imported Data from external csv-File. There we have a Column of dates and some Data for each Date.
For example like this:

Date;Data1;Data2;Data3
18.11.2020;0;1;1
19.11.2020;0;0;0
20.11.2020;0;01

Now we want to filter the Row, that shows only the last Date of all Rows, so the last Member of the Rows (here 20.11.2020 with Data1,Data2;Data3) How can we realize this?

2

Hi @MircoGabriel,
Welcome to the eazyBI community! :slight_smile:

To get the last date you can create a calculated member in the Time dimension that returns the last date you have in the Time dimension:

Aggregate(
  Tail(
    [Time].[Day].Members,1
  )
)

Please remember to disable Nonempty in Rows.

Last_Date
Last_Date1586×624 46 KB

best,
Gerda // support@eazyBI.com