Forum Discussion

Tummi's avatar
Tummi
Frequent Visitor
4 years ago

How to find average on matrix?

I've built out a matrix from a PBI dataset given to me, and I'm currently trying to build out an average column.    Each column provides a month with x amount of count values in each row. Is there ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Tummi what is the expected output?

  • Tummi's avatar
    Tummi
    Frequent Visitor
    4 years ago

    Output for the first Row:

    [January EXTENDED_PRICE (1,368,593) + February EXTENDED_PRICE (1,616,822) + March EXTENDED_PRICE (1,823,531) + April EXTENDED_PRICE (1,530,250)] / 4 Months = 1,584,799.

     

    Hoping to be able to do that for each row here.