Forum Discussion
Solved
retrieve text/string from cells in excel
Hi everyone, Thanks for your attention. I would like to retrieve several information to made counts of a certain information as for ETL. My question is that how can I write the DAX script to extr...
You may add a calculated column as follows.
Column = VAR s1 = "3. Defect type:" VAR s2 = "4. Initiator:" VAR p1 = SEARCH ( s1, Table1[Abnormal Description] ) VAR p2 = SEARCH ( s2, Table1[Abnormal Description], p1 ) RETURN MID ( Table1[Abnormal Description], p1 + LEN ( s1 ), p2 - p1 - LEN ( s1 ) )
Do you have a predefined list of defects? Do you need to maintain a separate count for each type?
I think we have the predefined list of defect. The separate count for each type is the column that I want to input to powerBI for visualization. I am not sure if it's the same meaning as maintain, thank you.