I am using PowerQuery to auto update a list of customer from a folder which the customer list in excel file will update once in a month.
I try several way manual way by copy the customer list in a month to compare another month. I wonder it there is any better way in PowerBI can get a visual to show the list of new/inactive customer based on my source.name?
In April, Intel is no longer customer at the same time we have Amazon onboard as new customer. Looking a way to compare new/inactive customer list once in a month via PowerBI get to know who are the new and inactive customer.