Forum Discussion
Help needed on Complex Scenario
Hello Community Group, I have recently came across a scenario where in the input file given link below has a table visual with columns Member & list of details. I wanted to achieve, the list of d...
Hi Anonymous ,
You can do this on the query editor and this will work has a single step using the split columns by delimiter:
Or you can do it using DAX to do columns you need to add the following syntax:
Column:
Test Column 1 = PATHITEM(SUBSTITUTE(Sheet1[List of details], ", ", "|"), 1) Test Column 2 = PATHITEM(SUBSTITUTE(Sheet1[List of details], ", ", "|"), 2) Test Column 3 = PATHITEM(SUBSTITUTE(Sheet1[List of details], ", ", "|"), 3) Test Column 4 = PATHITEM(SUBSTITUTE(Sheet1[List of details], ", ", "|"), 4)Measures:
Test Measure 1 = PATHITEM(SUBSTITUTE(SELECTEDVALUE(Sheet1[List of details]), ", ", "|"), 1) Test Measure 2 = PATHITEM(SUBSTITUTE(SELECTEDVALUE(Sheet1[List of details]), ", ", "|"), 2) Test Measure 3 = PATHITEM(SUBSTITUTE(SELECTEDVALUE(Sheet1[List of details]), ", ", "|"), 3) Test Measure 4 = PATHITEM(SUBSTITUTE(SELECTEDVALUE(Sheet1[List of details]), ", ", "|"), 4)Result in attach PBIX.
