Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mesam
New Member

clean data using power query

‎02-08-2024 11:32 AM
Delivery NumberDelivery Type CodeDelivery DateTimePlanned Good Issued DateSales Organization CategoryShipping Condition CodeShipping Plant NumberShip to CustomerSold to CustomerActual Good Issue DateInitial Commercial CodeSales Organization NumberPick DateGroup Code
3800332504ZTLDMonday, January 13, 2020Monday, January 13, 2020T99ZA083E+073E+07Monday, January 13, 2020CIFZA01Monday, January 13, 20208030
3102483284ZTLDThursday, July 9, 2020Thursday, July 9, 2020T99FRV73E+073E+07Wednesday, July 8, 2020DAPFR01Thursday, July 9, 20208030
3601790096ZTLDThursday, February 13, 2020Thursday, February 13, 2020T99ES083E+073E+07Tuesday, February 18, 2020CIPES01Thursday, February 13, 20208030
3052029572ZTLDWednesday, November 11, 2020Wednesday, November 11, 2020T99DE383E+073E+07Tuesday, November 3, 2020CIPDE01NULL8030
3001601788RLSunday, July 12, 2020Sunday, July 12, 2020J1ES054E+07#VALUE!Thursday, May 7, 2020FCACH01Sunday, July 12, 2020 
3001615836ZLFThursday, May 28, 2020Thursday, May 28, 2020J1CH013E+073.9E+07Thursday, May 28, 2020FCACH01Thursday, May 28, 20208030
3001601787RLSunday, July 12, 2020Sunday, July 12, 2020J1ES054E+07#VALUE!Thursday, May 7, 2020FCACH01Sunday, July 12, 2020 
3052009579ZTLDWednesday, November 11, 2020Wednesday, November 11, 2020T99DE383E+073E+07Tuesday, November 3, 2020CIPDE01Wednesday, November 11, 20208030


Hello,
I need some idea and help how to clean this data and can i fill null and values or what to do with and what can i put as visualisation for this data its for my supply chain data project i have to make it in power bi and upload file
thanks in advance

Best Regards,
Sumit

@Daniel29195 
@amitchandak 
@Idrissshatila 

Labels:
Message 1 of 4
472 Views
0
3 REPLIES 3
Anonymous
Not applicable

‎02-08-2024 09:17 PM

Hello Thanks for getting back to me 

i wanted to know logic what to replace or to filter null or what can we do to fill missing value because filling down might not be solution because there are 7.6 lac rows and 4 lacs are missing with some data

Message 4 of 4
454 Views
0
Anonymous
Not applicable

‎02-08-2024 05:59 PM

Hi @mesam ,

 

First select the data source you need to connect to in powerbi desktop and then go to power query to process the data.

vkongfanfmsft_3-1707443793847.png

 

For data processing, it is usually in the transform toolbar option, and for column processing it is in the add column tab.
Fill or replace NULL values in specific columns using conversion methods such as "Replace Value" or "Fill Down".

vkongfanfmsft_1-1707443430122.png

vkongfanfmsft_2-1707443491778.png

 

vkongfanfmsft_0-1707443381764.png

 

After cleaning the data in Power Query, you can load it into Power BI for visualization. For visualizations, consider creating charts and tables based on your specific analysis goals.

vkongfanfmsft_4-1707443970271.png

 

For more details, you can refer to below blog:

www.excelcampus.com

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Message 2 of 4
461 Views
0
Anonymous
Not applicable
In response to Anonymous

‎02-08-2024 09:23 PM

Hello Thanks for getting back to me 

i wanted to know logic what to replace or to filter null or what can we do to fill missing value because filling down might not be solution because there are 7.6 lac rows and 4 lacs are missing with some data

Message 3 of 4
452 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All