Forum Discussion

cpereyra's avatar
cpereyra
Helper I
6 years ago
Solved

Delimiter with Direct Query

I need to delimit the following column each time "~" shows. It won't let me do in in Edit Query because I have a Direct Query Connection. Does anyone know a dax to grab the text between "~" shows? Ke...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi cpereyra,

    Here I updated my sample PBIX file , please check if the newly added measures can get the expected results you want.In addition, if it is possible to handle with it in data source , then load the split columns into Power BI Desktop?

     

    Best Regards

    Rena

VasTg's avatar
VasTg
Memorable Member
6 years ago

cpereyra 

 

Try this...

 

 

Column = 
VAR A = IFERROR(FIND("~",'Table (4)'[Column1]),0)
VAR B = IFERROR(FIND("~",'Table (4)'[Column1],A+1),0)-1
RETURN IFERROR(MID('Table (4)'[Column1],A+1,B-A),'Table (4)'[Column1])

 

 

If it helps, mark it as a solution

Kudos are nice too

 

cpereyra's avatar
cpereyra
Helper I
6 years ago

It does work but how would you go about additional delimiters on the same column. 

 

Ex.

 

PEC~Insurances - ~Homeowner 

 

Would need back three columns

1- PEC

2 - Insurances

3 - Homeowner

 

Anonymous VasTg amitchandak 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi cpereyra,

    Here I updated my sample PBIX file , please check if the newly added measures can get the expected results you want.In addition, if it is possible to handle with it in data source , then load the split columns into Power BI Desktop?

     

    Best Regards

    Rena

    • Adeel_Yousaf's avatar
      Adeel_Yousaf
      Frequent Visitor
      4 years ago

      Your link is removed.