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 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.