Forum Discussion
Identify data difference between months
Hi,
I want to identify data difference like below screenshot.
Thanks,
Shiqi Chen
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
4 Replies
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/1361529Hi, 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
Hi,
Please show the exact result that you are expecting.
