Learn Power BI

  • Blog
  • Practice Questions
  • Nanodegree

Learn Power BI

Accelerate your Career and Get Certified

Fill Down Practice

Friday, June 18th, 2021

Dowload data for Fill Down Example

Opening the data in the Power Query editor and change the column type to date.

We have null values in the date field. We want to replace the nulls with the first non-null value above. Use the Fill Down option on the Transform tab of the Power Query editor:

Row 2 had the value from row 1, while rows 4 & 5 have values from row 3.

Column Quality, Column Distribution & Column Profile

Monday, May 17th, 2021

Here’ s a table showing what does what. To summarize, Column Profile does everything but only on one column. Column distribution shows you the distribution (obviously) and number distinct and unique. Column quality shows valid, error, and empty.

  Column Quality Column Distirubiton Column Profile
Multiple columns at once Yes Yes No
Valid Yes No No
Error Yes No Yes
Empty Yes No Yes
Distinct No Yes Yes
Unique No Yes Yes
Distribution No Yes Yes
Max No No Yes
Min No No Yes
Average, Standard Deviation, etc
(numeric only)
No No Yes

Column Quality

Open data in the Power Query editor, click the view tab, and select column quality. Three values are shown:

  • % Valid
  • % Error
  • % Empty

Column Distribution

Select column distribution, and we get:

  • Number distinct
  • Number Unique

Column Profile

Select column profile and we get:

  • count
  • error
  • empty
  • distinct
  • unqiue
  • empty string
  • min
  • max

For numeric data, you get additional summary:

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

  • Learn More
  • 4.6 Instructor Rating

  • 53,604 Students

  • 14,612 Reviews

  • 2 courses

© Power Bi Skills. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC