Forum Discussion
AVERAGEIFS
Id like to build a new column in my PowerBI table called "average". the formula that builds the average column I want to be similar to how excel's AVERAGEIFS folrmula works. Meaning the content of ...
calculated column=averagex(filter(table,table[vehicle]=earlier(table[vehicle])&&table[size]=earlier(table[size])&&table[color]=earlier(table[color])),table[price])
calculated column=averagex(filter(table,table[vehicle]=earlier(table[vehicle])&&table[size]=earlier(table[size])&&table[color]=earlier(table[color])),table[price])
That's it, thank you!!!