Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Average a column by another column

I am looking to create a column that calculates the average number of shipments per load. What DAX logic can i use to create this column? Any help would be greatly appreciated. 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    So you mean to aggregate a column based on another column category? If that is the case, you can take a look at the following formula if it meets your requirement.

    New Column =
CALCULATE (
    AVERAGE ( Table[Column1] ),
    FILTER ( Table, [Column2] = EARLIER ( Table[Column2] ) )
)

    Regards,

    Xiaoxin Sheng

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    that should be possible with DAX.

    Do you need it as a calculated column or as a measure?

     

    If you provide some sample tables or a Power BI file I can try to solve that. The solution depends a lot on the relationships and your data.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

    So you mean to aggregate a column based on another column category? If that is the case, you can take a look at the following formula if it meets your requirement.

    New Column =
CALCULATE (
    AVERAGE ( Table[Column1] ),
    FILTER ( Table, [Column2] = EARLIER ( Table[Column2] ) )
)

    Regards,

    Xiaoxin Sheng