Forum Discussion
Expression.Error: We cannot apply operator - to types Text and Text.
Hi BI Community, This is my first time posting here. Need help with a lingering issue. When i pivoted a column to create new columns, one of my new columns "Reason Code" contains error with: ...
Hi Anonymous
Can you share a screenshot that shows all columns? It looks like List.Sum is causing issue in Pivot. May be PQ is throwing error trying to do a mathematical operation on text field.
If possible share the PQ code after creating input table in PQ along with remaining steps. If not, share excel file removing sensitive information. This will be good for troubleshooting as well.
Mark this solution as accepted if it solves your issue.
Thanks
thingsclump
az38
Community Champion
Community ChampionHi Anonymous
I believe you use the "-" operator somewhere, no place for magic here
Pick your query, then open advanced editor and copy full text here in order to help you