Forum Discussion
Unpivot Other Columns Skips Columns with nulls
- 2 years ago
refer to the following
https://gorilla.bi/power-query/unpivot-and-keep-null-values/
refer to the following
https://gorilla.bi/power-query/unpivot-and-keep-null-values/
Ahmedx Thank you so much for your quick response! I went home last night thinking that I would probably have to implement a solution similar to the link you posted. I knew that was one workaround. I just hoping that there was something easier. Microsoft really needs to add "keep nulls" as an optional parameter to the Unpivot function. The default behavior is non-best practice in my mind. Leave it to the data scientist to determine if he/she wants to filter the nulls out after unpivoting. My worflows are pretty cumbersome and having to add additional steps like these just puts additional strains on my workflows. Sigh.