Forum Discussion
How to do conditional calculations on current table based on row values
This is a very simple thing I am trying to do, but for the life of me I can't understand how DAX does it. I want to find, say an average ( or any calculation really) of a column where certain other c...
add this code
= Table.Combine(Table.Group(#"Changed Type",{"Real Estate Type","Suburb"},{"n",each Table.AddColumn(_,"Average",(x)=>List.Average([Auction Price]))})[n])
Sorry I am looking to do this using DAX, not in Power Query