Identify data difference between months

[Shiqi_C]

Hi,

I want to identify data difference like below screenshot.

Thanks,

Shiqi Chen

[Ashish_Mathur]

Hi,

Please show the exact result that you are expecting.

[v-zhangti]

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.

[Shiqi_C]

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

[amitchandak · Accepted solution]

@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/b...