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. https://www.loom.com/share/adeff89d5b384eada47921a0f0f023e1

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.