Date of the last event

[gabrielvigo]

Hi everyone.

I have a table with some events.

I need identify the date of de last event and how many day passed.

I: 9/7/2018 - 1 day

II: 10/7/2018 - 0 day

III: 8/7/2018 - 2 day

IV:  3/7/2018 - 7 day

V: 4/7/2018 - 6 day

Is any formula that help me?

Thanks!

[v-yuta-msft]

Hi gabrielvigo,

"

I: 9/7/2018 - 1 day

II: 10/7/2018 - 0 day

III: 8/7/2018 - 2 day

IV:  3/7/2018 - 7 day

V: 4/7/2018 - 6 day

"

<--- What does this mean and could you clarify your logic and expected result?

Regards,

Jimmy Tao

[gabrielvigo]

It is an example of what I want as a result.
The date of the last event of each categeoria (I, II, III, IV, V) and how many days passed.

[Anonymous]

Hi @gabrielvigo

Can you try this for column I and then replicate the same for otehrs, if ths is what you want.

Max_I= CALCULATE(MAX(Table1[Date]),FILTER(Table1,Table1[ColumnI]<>0))

Thanks
Raj

[gabrielvigo · Accepted solution]

Hi, this was a big help.

The finally formula is:

Max_I = CALCULATE(MAX(Table1[Date]); Table1[I] <> 0; Table1[Date] <= TODAY())

I add a filter "<= Today", because I was having future results.