Forum Discussion
Exclude values with text in cells for average
Hello, I'm trying to build a dashboard in Power BI that will tell me average Turnaround times for events (TATS as named in my workbook), and my data is set to where if the TAT cannot be calculate...
v-juanli-msft
Community Support
Community SupportHi nlsantan
edhans's suggestion is correct, you could consider DAX function "Average" for ignore "null" value.
But I have puzzle what expected result you want.
Is this your expected results? (based on your words : calculate the average Admit to Order Time based on the values in Column B)
Best Regards
Maggie