How to track the movements of data between two tables

[Anonymous]

Hi apologies if the title doesnt make sense,

I am trying to create a measure that will track customer status between two tables, 

eg:

Last months data set

Customer	Warm	Hot	Dealt
A	12
B	13
C		4
D		5
E			9
F			3

This months data set:

Customer	Warm	Hot	Dealt
A		12
B		13
C		4
D		5
E			9
F			3

Is there a way to create a measure that will look at last months data and compare it to this months to tell me that customers "A" and "B" have moved from "Warm" to "Hot"?

Any suggestions would be appreciated 🙂

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you union these tables(add new column to store date) and unpivot columns on it, then you can simply use measure to compare records based on customer id and date.

Unpivot columns (Power Query)

Regards,

Xiaoxin Sheng