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.
MFelixThis would definitely work, but in case of import option, my apologize didnt mention the method of connection. However, in my case it is direct query mode (SSAS model). How this scenario can be achieved using this type of connection ?