How to Replace NULL with 0 (Zero) in Power Query (Power BI)

Опубликовано: 17 Октябрь 2024
на канале: Pettaka Technologies

19,515

Learn How to Replace NULL with 0 (Zero) in Power Query of Power BI. With Power Query, we can replace null with zero 0 and show 0 (Zero) instead of NULL then show NULL as 0. We can handle NULLS with Power Query M Functions in Power BI. You will get more videos like this in Power BI Power Query Tutorial Series. ‪@PettakaTechnologies‬
===========================================================
#tutorial #powerbi #powerquery #mfunctions #PettakaTechnologies #businessintelligence
===========================================================
Steps To Follow:
1) Data source should contain NULL values.
2) Select "NULL" contains column and right click.
3) Select "Replace Values" to replace the null values.
4) In "Value To Find", provide "null"
5) In "Replace With", provide 0
6) Replace NULL with 0 and Show 0 instead of NULL in Power Query.
==========================================================
Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies.
Power BI Tutorial for Beginners 2023.
Power BI by Pettaka Technologies.
Data Visualization with Microsoft Power BI.
==========================================================
This Power Query Replace Null with zero Tutorial video covers below topics:

1) How to replace Null with 0 (Zero) in Power Query?
2) How to covert Null to Zero in Power Query?
3) How to show 0 (Zero) instead of Null in Power BI?
4) How to remove Null from Power BI?
5) How to Handle NULLS with Power Query editor in Power BI Desktop?
6) How to deal with a "(NULL)" value in a data source?
============================================================
Playlists:

Microsoft Excel :    • MS Excel Tutorial

Excel VBA Macro :    • Playlist

Power BI :    • 🚀 PowerBI Tutorial for Beginners 😎

Power BI DAX Tutorial :    • Power BI DAX Tutorial
============================================================
For more awesome Power BI Tutorial videos like this. Visit our official YouTube channel.
***************************** - "Pettaka Technologies" - *********************************
========================================================================
Connect with us:
Subscribe |    / pettakatechnologies

Facebook |   / pettakatechnologies

LinkedIn |   / pettaka-technologies

Twitter |   / pettakatech

********************************** - "Happy Learning" - **********************************