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 contentSort by another columnAverage a column by another columnFind Most Recent Date Relative to another Date Column in Power QueryCreate Average Column using criteria from another columnYet another Sort by another Column error.
