topic Re: How to insert or get value after taking average? in DAX Commands and Tips

How to insert or get value after taking average?

Anonymous — Mon, 11 Jan 2021 12:23:41 GMT

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

Re: How to insert or get value after taking average?

amitchandak — Mon, 11 Jan 2021 12:57:22 GMT

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())

Re: How to insert or get value after taking average?

Anonymous — Mon, 11 Jan 2021 13:18:18 GMT

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

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