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,
Concatenate a field within IF/SWITCH statement
Hello Everyone, I'm new to Power BI. I have created a new column in my report using this SWITCH statement to group Institutions based on the below conditions. What I want is Concat "Control Group1" with INSTITUTIONS[NAME] within the SWITCH statement. Tried Using CONCATENATE and COMBINEVALUE functions as well as below method. All of those gives me " Error Message: OLE DB or ODBC error: [Expression. Error] We couldn't fold the expression to the data source. Please try a simpler expression.." Error. I'm using Direct Query mode in My Report. Appreciate If anyone can suggest me a method to concat a string with Table[ColumnName] within a SWITCH Statement INSTITUTIONS GROUP= SWITCH ( TRUE (), INSTITUTIONS[ID] = "d3a2efa8" || INSTITUTIONS[ID] = "721be8893","Control Group1" & " - " & INSTITUTIONS[NAME], INSTITUTIONS[ID]="729dbb5a-" || INSTITUTIONS[ID] ="b7ea8f29" || INSTITUTIONS[ID] ="6d85fa58" || INSTITUTIONS[ID] ="1df7d3ed","Control Group2","Control Group3") Thanks RushiSVery slow visual
Hi expert, I have a visual took over 97 second to show. The connection method is DQ and I've eliminated the column don't need. Can someone help me to revise the query so that the performance can improve? DEFINE VAR __DS0FilterTable = FILTER( KEEPFILTERS(VALUES('dim_time'[dataTime])), 'dim_time'[dataTime] >= DATE(2019, 12, 5) ) EVALUATE SAMPLE( 3502, SUMMARIZECOLUMNS( 'dim_time'[dataTime], __DS0FilterTable, "Maxmax_Process_PrivateBytes_coreServiceShell", CALCULATE(MAX('vw_osmetrics_hour'[max_Process_PrivateBytes_coreServiceShell])), "Maxmax_Process_WorkingSet_coreServiceShell", CALCULATE(MAX('vw_osmetrics_hour'[max_Process_WorkingSet_coreServiceShell])), "Maxmax_Process_PrivateBytes_dsa", CALCULATE(MAX('vw_osmetrics_hour'[max_Process_PrivateBytes_dsa])), "Maxmax_Process_WorkingSet_dsa", CALCULATE(MAX('vw_osmetrics_hour'[max_Process_WorkingSet_dsa])) ), 'dim_time'[dataTime], 1 ) ORDER BY 'dim_time'[dataTime]
