Error after unpivot other columns in Power BI desktop

[Analitika]

Hello,

I am getting an error after running Table.UnpivotOtherColumns. Errors are when null or zero values appear in table. Before this operation table contained some values different but after unpivot some data crashed, null and zeros only seems no data. 

Step formula:

= Table.UnpivotOtherColumns(#"Expanded Ledger1", {"a", "b", "c", "d", "e, "f", "g", "h", "j", "l", "n", "sdf", "objectid", "sdf", "sdf", "sdf"}, "sdf", "sdf")

[Anonymous]

Hi @Analitika ,

What kind of error message you get after unpivot the columns in Power Query Editor? Could you please provide the initial query data and a screenshot with the error message? Please exclude sensitive information before providing these information. Thank you.

In addition, please check the content in the following links and refer to the method in them to see if they can solve your problem.

Unpivot Data with Null or Error Values in Power Query

Dynamic Unpivoting in Power Query

Best Regards

[vivran22]

Hello @Analitika 

Unpivot always ignores the cell with null values. Before unpivot, I would recommend to replace all the nulls with 0, then unpivot, and then you might want to replace all the 0 back to null.

You may find the following handy:

https://social.technet.microsoft.com/Forums/en-US/fc15fa9c-3f16-47cc-98fe-59f48f0a44b8/power-query-d...

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)


https://www.vivran.in/

Connect on LinkedIn