Compare Date from last two available dates and filter what's different

[Anonymous]

Hello all!

I have a database where I populate it weekly with information of some projects.

DATE	ID	STATUS
21/09/2021	project1	Idea
21/09/2021	project2	Idea
28/09/2021	project1	Business Case
28/09/2021	project2	Idea
05/10/2021	project1	Business Case
05/10/2021	project2	Business Case

Is possible to create a table to show only the information of the last two available dates, and highlight when the information from one date to another is different?

ID	28/09/2021	05/10/2021
project1	Business Case	Business Case
project2	Idea	Business Case

or create a new column that shows when there was a change...

ID	28/09/2021	05/10/2021	Change?
project1	Business Case	Business Case	No
project2	Idea	Business Case	Yes

Furthermore, is it possible to create a filter to show only projects that have some kind of change from one date to another?

Best Regards,

[Anonymous]

Hi @Anonymous ,

Do you want a visual or a table?

Best Regards,

Jay

[Greg_Deckler · Accepted solution]

@Anonymous See if the attached pbix helps (below sig)