cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jayfemi
Helper I
Helper I

DAX

Hi am looking to to create a calculated column and measure looking at the amount of times a name appears and then get a count.

i.e. "derek" but the area i am struggling with is where multiple names occour in one cell i.e. " Josh Greg Jamie Susan" is there anyway to have a dax formual look into a colunm and pick out each individual occourance and count it?

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft
Microsoft


@Jayfemi wrote:

Hi am looking to to create a calculated column and measure looking at the amount of times a name appears and then get a count.

i.e. "derek" but the area i am struggling with is where multiple names occour in one cell i.e. " Josh Greg Jamie Susan" is there anyway to have a dax formual look into a colunm and pick out each individual occourance and count it?


@Jayfemi

Not in DAX, but in Power Query, you shall re-model your data by split and unpivot.

 

spilt&unpivot.gif

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft
Microsoft


@Jayfemi wrote:

Hi am looking to to create a calculated column and measure looking at the amount of times a name appears and then get a count.

i.e. "derek" but the area i am struggling with is where multiple names occour in one cell i.e. " Josh Greg Jamie Susan" is there anyway to have a dax formual look into a colunm and pick out each individual occourance and count it?


@Jayfemi

Not in DAX, but in Power Query, you shall re-model your data by split and unpivot.

 

spilt&unpivot.gif

Abduvali
Skilled Sharer
Skilled Sharer

Hi @Jayfemi,

Just drag and drop the names and do a count on them:

Capture30.PNG

 

Regards

Abduvali

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.