Forum Discussion
Data cleansing
Hi,
Request your guidance to overcome this issue;
In our sales dashboard were are uploading DATA on a daily basis in excel format, we are getting the DATA from our parent company and have...
Hi,
This was the top result when i Google:
https://learn.microsoft.com/en-us/training/modules/automate-data-cleaning-power-query/
I have not used it by my self, but it looks What youre after 🙂
Br
Marius
Hi,
PQ have a lot of data cleansing functionalities, but its hard to do ut automaticly if the issues are diffrent from month to month. If the cleansing you are doing in excel is the same all the time it should be possible to implement this in PQ so it does it automaticly. But if its diffrent every time its harder. All depends on the data and What is the problem time to time.
Br
Marius
Hi mariussve1,
thanks a lot, this one is perfect
regards,
dsmitha