Forum Discussion
Measure for Text in Direct Query Mode.
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,
5 Replies
Hi TaufikMaggangka ,
Try using this DAX to substitute the space with comma:
Measure= SUBSTITUTE(Table[CovidSymtptomsScreen]," ", ",")
Hi Tanushree_Kapse , i would like to try but cant found my name of my table. please image atatchedTaufikMaggangka , you are writing the syntax wrong.
One equal to sign only!!
