Conditional formatting

[planning]

Hi all,

I have a table like this:

Boat          Date         Status

A         15/07/2020       2

A         16/07/2020       1

A         17/07/2020       2

B         15/07/2020       1

B         16/07/2020       2

B         17/07/2020       1

How can I add a new calculated column showing in each row the status of the same boat in the previous day, showing as follows:

Boat          Date         Status     Status Day Before

A         15/07/2020       2                       -

A         16/07/2020       1                      2

A         17/07/2020       2                      1

B         15/07/2020       1                       -

B         16/07/2020       2                      1

B         17/07/2020       1                      2

Thanks!

[Greg_Deckler · Accepted solution]

@planning - Try:

Status Day Before =
  VAR __DayBefore = MAXX(FILTER('Table',[Date] = EARLIER('Table'[Date]) - 1 && [Boat] = EARLIER('Table'[Boat])),[Status])
RETURN
  __DayBefore

[amitchandak]

@planning , As new column

//continous day

Last day value = maxx(filter(Table, [date] = earlier([date]) -1 && [Boat] = earlier([Boat])),[Status])

// noncontinous day

Last day value =
var _max = maxx(filter(Table, [date] < earlier([date]) && [Boat] = earlier([Boat])),[date])
return
maxx(filter(Table, [date] = _max && [Boat] = earlier([Boat])),[Status])

for measure for same case find measure here

https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...