Forum Discussion
Identify data difference between months
- 4 years ago
Shiqi_C , try if the code of customer can work for the part, New or removed
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Hi, Shiqi_C
You can try the following methods.
Table:
Table 1 = CALCULATETABLE('Table','Table'[Month]="March")Table 2 = CALCULATETABLE('Table','Table'[Month]="April")
Then join Table 1 and Table 2 with the part field.
This view shows that D1 is unique to March and F1 is unique to April.
Is this the result you expect? If not, please show the output you expect in the form of a picture.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for the insight. However, this solution is simply not flexible enough. My data table is too complex for this solution.
Hope anyone else would find this useful.
Thanks