Hi apologies if the title doesnt make sense,
I am trying to create a measure that will track customer status between two tables,
Last months data set
This months data set:
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 🙂
Go to 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)
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.