Forum Discussion
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 filled only first cell. Rest cell should be 0 or null.
For example, if Projekt#Investor# is wpd AG then only first cell of wpd AG will be filled with the resulted average. is it possible.
Please kindly help.
Regards
Karim
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())
2 Replies
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 first of all thank you very much for your reply.
But unfortunately, I got blank for all. Please kindly check the picture.