Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to insert or get value after taking average?

Hello everyone,   I need little help with average. I want to create a column after taking average based on Projekt#Investor#. In the resulted new column, avg_betreuung, I want resulting value fille...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , The column I need take Average is not clear. So used

     

    First add an index column- https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

    and then this formula a new column in DAX

    new column =
    var _index = Minx(filter(Table, [Projekt#Investor#] =earlier([Projekt#Investor#])),[Index])
    return
    if([Index] =_index, averageX(filter(Table, [Projekt#Investor#] =earlier([Projekt#Investor#])),[betreuung]), blank())

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , The column I need take Average is not clear. So used

 

First add an index column- https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

and then this formula a new column in DAX

new column =
var _index = Minx(filter(Table, [Projekt#Investor#] =earlier([Projekt#Investor#])),[Index])
return
if([Index] =_index, averageX(filter(Table, [Projekt#Investor#] =earlier([Projekt#Investor#])),[betreuung]), blank())

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak first of all thank you very much for your reply. 

 

But unfortunately, I got blank for all. Please kindly check the picture.