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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    why not just use filler

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

you are welcome