Keep null Values During UnPivot Operations - Monkey Shorts Episode 043
By default, when you unpivot a set of data in Power Query, all null records are suppressed. But what if you need them in your unpivoted data set? In this week's episode of Monkey Shorts, Ken shows two different methods of doing so, as well as discusses the impacts of each.