Forum Discussion
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...
why not just use filler
=filter('OH_total', type="LCM" && impact>100000)
why not just use filler
=filter('OH_total', type="LCM" && impact>100000)
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.
Sorry, I was wrong, that did in fact fix it. Thanks!
you are welcome