Forum Discussion
Helper IProblem using sumx() with containsstring
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.
Community ChampionYou can split the column in power query or use Add column from example option to extract the required text into another column!
for example right click on display id and select add column from example option from the menu
then you will find a new column with 'Column 1" heading in extreme right
in the first row you need to just type SIN ( since the first row value is data_sin) and press enter and you will get the values accross the column and press ok to continue
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
Hi 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.