Forum Discussion
CLANG10
Helper I
Helper IProblem using sumx() with containsstring
Hi, I am using CONTAINSSTRING to look for a specific text in a column, however i can't find the table/column, so i try using SUMX in the expression to be able to locate the column. An error occu...
Hi CLANG10 ,
try this measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CLANG10Helper I
Helper II got the data from another live source, so i can't use power query, can only use DAX. Thanks anyway!
Any solution using DAX expression?
mangaus1111
Solution Sage
Solution SageHi CLANG10 ,
you can use these 2 columns:
Column 1 = REPLACE([Text],1,5,BLANK())
Column 2 = LEFT([Column 1],SEARCH("_",[Column 1])-1)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- CLANG10
Hi seemd like my live data source is preventing me to use data transform/power query nor split any column. I can only create DAX measures, thus i can't test out your solution. Thanks anyway!
- mangaus1111
Hi CLANG10 ,
try this measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- CLANG10
Many Thanks, it works this way!!