Dealing with Nulls & Blanks in Power Query: Best Practices|| From Nulls to Clean Data
Вставка
- Опубліковано 11 лип 2024
- When handling data in tools like Power Query or databases, it's essential to identify whether the field contains nulls, blanks, or both, and then apply appropriate treatments or transformations based on the context and desired outcomes.
In this video I have shared 5 diffrent ways to handle null and blank values in power query editor.
#dataanalytics #powerbitutorial #powerquery
Chapters:
00:00:00 Intro
00:00:46 Diffrence between nulls and blanks
00:03:05 Method 1 -Filtering nulls
00:06:30 Method 2-Replace nulls and blanks
00:08:33 Method 3-Fill up and down
00:10:33 Method 4-Conditional check
00:14:38 Method 5- Custom column
00:18:20 Conclude
Playlist:
Excel for beginners: • Excel for beginners
SQL: • SQL
Power BI tutorial: • Power bi tutorial
Scenario based questions with solutions in PBI: • Scenario based questio...
Interview preparation for data analytics: • Interview prepation fo...
👍 Enjoyed the video? Don't forget to like, share, and subscribe for more Excel tips and tutorials!
📌 Connect with us:
Telegram: t.me/+-I4I7YtxZldjNGY0
Instagram: analytics_with_...
Twitter: DataPandits?t=EN9...
📧 Have questions or suggestions for future tutorials? Drop a comment below! Let's excel together! 🚀
Very very impressed. You are the only youtuber that has made a number of options to replace blank values. Thank you greatly for expanding on this topic.
Glad you liked it ♥
NICE ONE!
Thanks! ❤️
You are an awesome trainer with a detail-oriented approach It helps a lot in learning
Happy to hear that!Thank you so much ❤
Good to see Your Video Maam, after long break, Thanks :)
My pleasure 😊
I found all the points i looking for...Thanks mam
Most welcome 😊
super tutorial❤
Thank you!!
Nice explanation but can you please provide dataset also for practice
Sure will upload in description.Thanks for watching❤
tunjangan BPJS dan TK masuk gak?
How can we replace dates if there are null & blank
You can replace it with default date value or you can use m code for same.
@@AnalyticswithAsmi-6809 but my question is how can put any date in that place, i can't put zero if its number or NA in place of text. But how can I replace date?
Before Type Change Replace Blanks with new number equivalent to date you wish to insert