Рет қаралды 4,240
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! 🚀