Forum Discussion
itchyeyeballs
Impactful Individual
9 years agoAVERAGEX Conditional Logic
Hi all, I'm having trouble getting an averagex function to work correctly, my data has one row per person, I need a function that checks a flag column then choses which column to sum as appropria...
Greg_Deckler
Community Champion
9 years agoMyAverageX = AVERAGEX(table,IF(table[flag]=1,table[Col1],table[Col2]))
As a measure.