Teaching analytics with modern Excel
nulls in Excel Power QueryIn Excel's Power Query, blank values are treated as nulls to signify the absence of data or to indicate an unknown, missing, or inapplicable value. This approach is consistent with database and …
Continue Reading about How to replace blank values with nulls in Excel Power Query →
null and missing values in Power QueryI've written in the past how Power Query enforces good data hygiene practices that aren't always in Excel. One of those is the presence of a null or dedicated missing value. This has been a real …
Continue Reading about How to understand null and missing values in Power Query →