topic Re: DAX help to find difference in data in DAX Commands and Tips

DAX help to find difference in data

HariPower — Fri, 29 Apr 2022 04:47:51 GMT

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

Re: DAX help to find difference in data

amitchandak — Fri, 29 Apr 2022 06:53:04 GMT

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/ba-p/1361529

Re: DAX help to find difference in data

HariPower — Fri, 29 Apr 2022 08:31:10 GMT

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

Re: DAX help to find difference in data

HariPower — Wed, 04 May 2022 08:19:35 GMT

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...

Re: DAX help to find difference in data

Anonymous — Fri, 06 May 2022 07:43:15 GMT

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