User Profile
SGGusau
Copper Contributor
Joined Feb 21, 2021
User Widgets
Recent Discussions
Re: Unable to use power query to combine files in folder synced from SharePoint due to system file
You probably have tried filtering out the system file, if not, right click the cell and choose DOES NOT EQUAL. Alternatively in the Extension column, filter to only the file extension you wish to keep, for eg. xlsx. If this doesn’t resolve it, you might need to do the filtering higher up in the path.913Views0likes1CommentRe: Formula extract digits
And that's where PQ excels. The one column data, in this example, would easily get TRIMED, CLEANED and SPLIT, all using the user interface. 3-5 clicks and a job well-done can be loaded back onto the worksheet. The column can grow as long as possible with similar "dirty" data and all it takes is hitting the Refresh button.1.5KViews0likes0CommentsRe: Help with self-study
You are welcome, Mohammed. You did not mention the particular level you are most interested in. Even the basic and fundamental course (AI-900) is woven around redumentries of AI/ML. I still assure you the link I provided can lead you to several more resources along the lines of your needs. Make sure you check Microsoft Learn and conduct a search for your topics/roles. This site could even be your one-stop shop. Again, best of luck. Sani.847Views0likes0Comments
Recent Blog Articles
No content to show