DAX help to find difference in data

[HariPower]

Need a help for the below ...

I have the below data in a table with 2 columns ...imported from an excel file... ( No sql server etc, but using excel import as powerbi dataset)

Now a simple report I want as a powerbi dashboard view, which will need to show the additions and deletions ... basis feb22 rows vs Jan22 rows...

Needed output like this...

Added

XYZ

Deleted

ABC

JKL

BASE DATE in table...

Jan22  ABC

Jan22  DEF

Jan22  GHI

Jan22  JKL

Feb22 DEF

Feb22 GHI

Feb22 XYZ

[Anonymous]

HI @HariPower,

Did these records directly replace and update your data source or append after original records?
If you mean the first one, current power bi does not include historical data analysis feather to cache history data and compare it with current records.

If you mean the second one, you can use the date as the group to filter records, then you can use except function to get the different records.

EXCEPT function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

[amitchandak]

@HariPower , refer my customer Retention, that can help. You can create a date using the month year if needed. here you can use a count or a column as a measure (sales/net in blog). Customer is your second column

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...

[HariPower]

HI Amit, using your customer solution, I could implement what is required.  Just took example of 3 measures from your implementation, worked around and done.  Thanks for guidance...

[HariPower]

Thanks Amit, checking your report if that implementation suits my purpose...one thing sure I understood is that dates table should be part of my ask to enable what I want...thx