Only show new cells or changes made in cells after update

[cris007]

Hello Community, 

I have a dashboard that looks like below:

Brand	2017	2018	2019	2020	2021	2022	2023	2024
A	New		Reshaped		End
B		New		Reshaped			End
C	New				Reshaped			End
D		New				Reshaped
E					New	Reshaped

Each months,  the dataset is updated and values changed, or values are added or new brands are added in the Brand column. 

The problem: Each months, I need a solution that will show only new cells or cells that have changed in a separate dashboard. 

For exemple, next month, the dashboard will look like below ( The new values or values that have changed compared to the previous dashboard are in red color)

Brand	2017	2018	2019	2020	2021	2022	2023	2024
A	New		Reshaped		End
B		New		Reshaped			Reshaped
C	New				Reshaped			Reshaped
D		New				Reshaped	End
E					New	Reshaped		End

The solution should therefore looks like below: 

Brand	2023	2024
B	Reshaped
C		Reshaped
D	End
E		End

- Is there a way to build this solution without having to make an extraction each month and compare these two extractions?

- if not, what would be the function to compare 2 datasets or 2 dashboard and only return what has changed/new?

NB: The source file looks like the dashboard, as a pivot table. The excel file has been pivoted in the backend of my Power BI. 

Thanks for the help

[cris007]

Thanks @some_bih I actually found a way to do it now : merge two tables, add conditional column based on the values form the two tables and filter the conditional column when values are different. 

[some_bih]

Hi @cris007 one of the alternatives is to create dynamic filter based on range.

Check links for example and details. I hope this help.

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range