Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter out errors in CalculateTable

Hi,  I have created a new table named "LCM_100K" based on another table named "OH_Totals" . I am bringing OH_Totals in via Power Query which removes any rows with errors. However, when I create a new table "LCM_100K" based on OH_Totals, errors are getting in the way. Do I need to write my formula in such a way to remove that error? How would I do that or how would I fix? Thanks.

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    why not just use filler

     

    =filter('OH_total', type="LCM" && impact>100000)

4 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    why not just use filler

     

    =filter('OH_total', type="LCM" && impact>100000)

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Did you mean to do it like this within CALCULATETABLE? Or should that happen somewhere else? Tried it within CALCULATETABLE but the result seems to be the same.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Sorry, I was wrong, that did in fact fix it. Thanks!