bklyn3Advocate II4 years agoSolvedAverage value based on two columns in another table Hello PowerBI community I have two tables PreviousOrders and FutureOrders. PreviousOrder Facility Processing Time OrderType A 13 Express A 15 Normal B ...Show Moretamerj14 years agoHi bklyn3 you build a many to many relationship between the two tables based on the facity column. Then New columnAVERAGEX (FLITER (RELATEDTABLE ( PreviousOrder ),PreviousOrder[OrderType] = FutureOrders[OrderType] ),PreviousOrder[Processing])
tamerj14 years agoHi bklyn3 you build a many to many relationship between the two tables based on the facity column. Then New columnAVERAGEX (FLITER (RELATEDTABLE ( PreviousOrder ),PreviousOrder[OrderType] = FutureOrders[OrderType] ),PreviousOrder[Processing])
tamerj14 years agoHi bklyn3 you build a many to many relationship between the two tables based on the facity column. Then New columnAVERAGEX (FLITER (RELATEDTABLE ( PreviousOrder ),PreviousOrder[OrderType] = FutureOrders[OrderType] ),PreviousOrder[Processing])
Related contentAverage a column by another columnCreate Average Column using criteria from another columnAverage based on distinct values in another columnYet another Sort by another Column error.Find Most Recent Date Relative to another Date Column in Power Query
