Reply
WishAskedSooner
Resolver III
Resolver III

Unpivot Other Columns Skips Columns with nulls

Hi Power Query Experts! I am a new user and still learning, so I really appreciate your help.

 

I have a table that I am unpivoting. There are columns in the table that have no values i.e. all nulls. When I execute the following command:

 

Table.UnpivotOtherColumns(MyTable, Keys, "Attr", "Value")

 

It skips the columns that have nulls. According to the wiki, there are no additional parameters for the above function to prevent this behavior. Therefore, what should I do because I actually need the unpivot to include the null columns for my workflow?

 

Thanks so much!

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User
2 REPLIES 2
Ahmedx
Super User
Super User

@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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)