Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need help to Split this text based on delimeter "Comma"
can anyone help me with "DAX"?
Thanks in Advance
Solved! Go to Solution.
try
Column =
var _start = SEARCH("""Type", [Column1],,0)
var _finish = SEARCH(",", [Column1], _start)
RETURN
IF(_start > 0, MID([Column1], _start, _finish - _start), BLANK() )
@Mariusz : no, i need to use DAX, the above DAX is looking fine but it's just giving me error because few rows in my table doen't have "Type", thank you.
@yodha , seem like a json data check
https://www.youtube.com/watch?v=ipI6mrWLQKA
https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/
@az38 : Thank you so much for the response but this is giving me error because few rows doesn't contain "Type" in my Table, can you tell me how to modify this DAX ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |