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

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.