I am in the process of rebuilding a report and seem to have run into another issue. I created a calculated column that sums the total currency of three other columns, and when I try to include it into my table I have the following error. Anyone encountered this before or know why this is happening? Thanks
Hi @adclabby ,
I agree with lbendlin. According to the error, it seems that your issue was caused that Power BI couldn't find the column 'CPO Total'.
Please make sure whether you changed the name of it or remove it in Power Query Editor. This will cause Power BI couldn't find it and show error.
You can check the calculated column which sums these columns. I think the red wavy line is displayed below 'CPO Total' column.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
I have never received this error before so it is new to me, I am unsure how to solve it so I am stuck because my visual will not display my data correctly. Any advice on how to troubleshoot this problem or an explanation as to what it means or why it is happening would be amazing.
It mentions a column name. Can you identify the code in your calculated column that references it?
