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 find average using index substring

Hello All, 

 

Can someone help me  with the DAX command.

 

I would like to calculate the average of  score based on first 2 decimals of my Index Value.Basically the average for O.1, O.2. O.3......

namitajuneja15_0-1660658073217.png

 

 

Let me know, how to do this. I am really struggling.

 

Thanks,

 

1 REPLY 1
Fowmy
Super User
Super User

@Anonymous 

First, add a column in Power Query: Add Column >  Extract > Text Before Delimiter

 

Fowmy_0-1660658900850.png
Choose the options under Advance

Fowmy_1-1660658953131.png

The in the Data model, add the following column using DAX

Avg Index Value = 
CALCULATE(
    AVERAGE(Table1[Value]),
    ALLEXCEPT(Table1, Table1[2 Digit Index] )
)


Result

Fowmy_2-1660659001428.png

 





 

 





Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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.