User Profile
AlwaysLearner
New Member
Joined 11 months ago
User Widgets
Contributions
Re: Beginner Needs Help: Can't Figure Out How to Transform "Dirty" Date Format Using UI Only
Hi Omid, thank you very much for the file and the time you have invested in. But unfortunately this is not helpfull. As I already new how the Clean file has to look like. My problem is that I do not understand how the transformation is done. That means I need a walkthrough how to handle the file in Power Query to reach the "clean" State. I'm greatful for the link to you youtube channel. I will have a look into it. Thank you very much1.3KViews0likes0CommentsRe: Beginner Needs Help: Can't Figure Out How to Transform "Dirty" Date Format Using UI Only
Hi Sundar, thank you very much for the file and the time you have invested in. But unfortunately this is not helpfull. As I already new how the Clean file has to look like. My problem is that I do not understand how the transformation is done. That means I need a walkthrough how to handle the file in Power Query to reach the "clean" State.1.3KViews0likes0CommentsBeginner Needs Help: Can't Figure Out How to Transform "Dirty" Date Format Using UI Only
Hi everyone, I'm a complete beginner with Power Query and I'm really struggling with what's probably a basic transformation. I have an Excel file with two tabs - the first contains my "dirty" data with a messy date format, and the second shows what I want the "clean" output to look like. I've been trying for hours using the UI (transpose, transform, remove headers, etc.) but I just can't figure out how to get from the dirty format to the clean format. I feel like I'm missing something fundamental about how these transformations work. I know this is probably Power Query 101 stuff, but I'd really appreciate any guidance on the steps I should be taking. I learn better by seeing the actual UI steps rather than code, if possible. Would anyone be willing to take a quick look and point me in the right direction? I'm happy to share the file if that would help. Thanks so much for your patience with a newbie! Here the link to the file: https://foresightbi.com.ng/wp-content/uploads/2020/05/3.-Badly-Structured-Sales-Data-3.xlsxSolved1.4KViews0likes8Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.