Table Pivot = Cannot convert null to logical

(0) Share

Report

Posted on by ojohn

Hello. I am trying to pivot some columns with power query and something broke in the process since the last time I set it up.

The code auto generated by power bi:

= Table.Pivot(#"Added Custom3", List.Distinct(#"Added Custom3"[SeriesType]), "SeriesType", "Value", List.Sum)

The error message:

Expression.Error: We cannot convert the value null to type Logical.
Details:
Value=
Type=[Type]

I know that something is coming up null, but am not adept at the code enough to know how to remove the null values during this step. The "Value" column is a decimal, and transforming nulls to 0 will likely affect other calculations done after this step. Any suggestions on what the adapted code should look like?

Thank you!