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:
