Forum Discussion
String text parsing-where, why, and how
Hi NicLeam.
>>1. Is there a summary of the query step outcome--e.g., where PowerBi would tell me "X number of times 'OldValue' was replaced by 'NewValue'?"
Power bi only alert you that: current value will be replaced. Since these replacement operation not affect the original datasource, you not need to worry about this.(you can change the active steps to review the data in different steps).
>>2. What's the best/quickest way to determine if a step 'worked'?
I'd like to suggest you refer to below link which about use multi conditions to replace value:
Multi Condition Logic In Power Query
>>3. I have several large text fields. I want to create flags to determine which key terms occur.
I think you can add new column and use text.contains function to check specific characters string.
Function DescriptionText.Contains Returns true if a text value substring was found within a text value string; otherwise, false. >>Do I need to do it in Query Editor?
For these modify operations such as 'replace', 'rename', 'filter', 'upper', I think power query will be suitable. Another calculations and check value opertions, I think dax will be suitbale.
Regards,
Xiaoxin Sheng
Hi NicLeam.
>>1. Is there a summary of the query step outcome--e.g., where PowerBi would tell me "X number of times 'OldValue' was replaced by 'NewValue'?"
Power bi only alert you that: current value will be replaced. Since these replacement operation not affect the original datasource, you not need to worry about this.(you can change the active steps to review the data in different steps).
>>2. What's the best/quickest way to determine if a step 'worked'?
I'd like to suggest you refer to below link which about use multi conditions to replace value:
Multi Condition Logic In Power Query
>>3. I have several large text fields. I want to create flags to determine which key terms occur.
I think you can add new column and use text.contains function to check specific characters string.
| Text.Contains | Returns true if a text value substring was found within a text value string; otherwise, false. |
>>Do I need to do it in Query Editor?
For these modify operations such as 'replace', 'rename', 'filter', 'upper', I think power query will be suitable. Another calculations and check value opertions, I think dax will be suitbale.
Regards,
Xiaoxin Sheng
Thank you for your feedback! I will play around w/the CONTAINS function some more and see if I can get it to work.