Forum Discussion

tina345's avatar
tina345
Icon for Helper II rankHelper II
5 years ago

count with like condition on text

Hi Experts,  I have data like and I have been trying to take a counts for each type based on each type (with like condition) and another set of count based on date if it is current month. So, 1st ...
Need Help
tina345's avatar
tina345
Icon for Helper II rankHelper II
5 years ago

This looks better solution for me to create new column.

I am still trying to come up with DAX expression for this.

My filed is 'apple orange', with space delimiter..I am trying to extract 1st part.

 

Is there any DAX expression that you can help me with?

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

This is easier to do in the query editor (which has nice functions like Text.BeforeDelimiter) but possible in DAX combining functions like LEFT and FIND something like this (untested):

 

LEFT ( myTable[Type], FIND ( myTable[Type], " " ) - 1 )