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,
