Better than average conditional formatting

I am trying to set up conditional formatting for better than average. I am not quite sure what I am doing wrong, I created a loom video for this.

You were close :slight_smile: By default any column name refers to thisRow's value, so you compared average of a single New subscribers value with itself.

To get all New subscribers values you need to use Table.Column.Average() syntax. There is an example:

1 Like

Thanks so much! I really appreciate that. I knew it was something simple.