Measure for Text in Direct Query Mode.

[TaufikMaggangka]

Hi All,,,

I need help with "Direct Query" mode.

Basically, I want to retrieve value from column into new value. I try with custom column but not working in the "direct query mode".

Here my sample column and the value, I name it:
"CovidSymtptomsScreen"

fever lossofsmell cough

cough fever

fever lossofsmell

headache cough

I hope the result if I create table visualization will be like this :
"CovidSymtptomsScreen"

Fever, Loss of smell, Cough

Cough, Fever

Fever, Loss of smell

Headache, Cough

Stress about this, I try a lot of different ways such as using text.combines, text.contains with if statement but doesnt work in directquery mode. Some one told me that it can be done with measure, but quite confusing since he didn't give me an example of measure and i am new with power bi.

Your prompt response will be appreciated.

Thank you,

[Tanushree_Kapse]

Hi @TaufikMaggangka ,
Try using this DAX to substitute the space with comma:
Measure= SUBSTITUTE(Table[CovidSymtptomsScreen]," ", ",")

[TaufikMaggangka]

Hi @Tanushree_Kapse , i would like to try but cant found my name of my table. please image atatched

[Tanushree_Kapse]

@TaufikMaggangka , you are writing the syntax wrong.
One equal to sign only!!

[TaufikMaggangka]

Hi @Tanushree_Kapse 
I have delete the = but still cannot find the table.

[Tanushree_Kapse]

@TaufikMaggangka , instead of measure... create a new column and use the formula