Share
ReportHello. 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!
Categories:
I have the same question (0)
All responses (
Answers (
493
