Forum Discussion
Calculating Average by multiple columns
Hi All, I am trying to calculate average based on multiple column. Would have used AverageIfs in excel for this calculation. Example: Average Revenue by "FY Quarter, Month, City and product" an...
amitchandak
Super User
Super Userskolathu , Assume you sum values and then table Avg, then you can try measure like. Same is true for Max /min etc
AverageX(summarize(Table, Table[Month Year], Table[product], "_sum", calculate(Sum(Table[Value])) ) , [_sum])