Skip to Content

### Webi Need Max date across multiple rows?

Hello All,

Below is my raw data in Webi and I am looking for formula which will return each employee with latest date. The tried various different ways but what it returns the max date from the whole data set.

Any help is appreciated!

Thank You.

capture.jpg (30.7 kB)
##### Add comment
10|10000 characters needed characters exceeded

### 3 Answers

• Best Answer
Apr 26, 2017 at 07:54 PM

use this.

=max(date) in (employee)

Or create variable and filter on to get the max date row.

Var=if(date=max(date) in (employee)) then "show" else "hide"

Apply filter on Var equal to show

##### Add comment
10|10000 characters needed characters exceeded
• Apr 26, 2017 at 08:16 PM

Thanks Amit I am already doing this using

=If(Max([Date]) In ([Employee]) = [Date]) Then 1 Else 0

But it returns only E3 01/06/2016

##### Add comment
10|10000 characters needed characters exceeded
• AMIT KUMAR Sam Govaski

no it's wrong.

follow these steps.

V Date=ToDate([Date];"MM/dd/yyyy")

V Date is now with date data type.If you will use Formatdate function then it will convert to string datatype.

=If(Max([V Date]) In ([Employee]) = [V Date]) Then 1 Else 0

• Apr 27, 2017 at 03:45 PM

With Help of Amit Kumar I followed the steps and only change I did was I was using Employee Name

If(Max([V Date]) In ([Employee NAME]) = [V Date]) Then 1 Else 0

Instead I converted the date to Todate first V Date=ToDate([Date];"MM/dd/yyyy") and then

=If(Max([V Date]) In ([Employee ID]) = [V Date]) Then 1 Else 0

Worked like a charm!

##### Add comment
10|10000 characters needed characters exceeded