Forum Discussion
DAX help to find difference in data
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...
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