Forum Discussion
Error loading table but query editor shows no error rows
Hello ROKRI
first of all I would reccomend to use this formula, instead of yours
= Table.AddColumn(#"Added Receivable Balance", "Current FY Actual ICR %", each if [FY20 Actual Direct]=0 then null else ([2020 Expenditure]-[FY20 Actual Direct])/[FY20 Actual Direct], type number)otherwise you have a mixture of data-type text and number.
In Power Query you can use the try otherwise syntax to get the errors, but I think the NaN is not covered here.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello ROKRI
first of all I would reccomend to use this formula, instead of yours
= Table.AddColumn(#"Added Receivable Balance", "Current FY Actual ICR %", each if [FY20 Actual Direct]=0 then null else ([2020 Expenditure]-[FY20 Actual Direct])/[FY20 Actual Direct], type number)
otherwise you have a mixture of data-type text and number.
In Power Query you can use the try otherwise syntax to get the errors, but I think the NaN is not covered here.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
