Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

picture.jpg

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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

 

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

picture2.png

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.