cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
ItSupportElm
Helper III
Helper III

Replace values in of column in direct query

‎11-26-2019 02:50 AM

Hello,

 

Is it possible to change values in direct query ? Using dax to do it or something else ?

 

Thanks for the futur answers.

Labels:
Message 1 of 2
855 Views
0
1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

‎11-26-2019 10:14 PM

Hi @ItSupportElm ,

 

We cannot replace it directly, but we can create a new calculated column to meet your requirement:

 

ColumnName = SUBSTITUTE('Table'[ColumnToReplace],"OldText","NewText")

 

9.PNG

 


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Parent-part-is-not-showing-in-the-table-that-display-the-results.pbix
Message 2 of 2
824 Views
1 REPLY 1
v-lid-msft
Community Support
Community Support

‎11-26-2019 10:14 PM

Hi @ItSupportElm ,

 

We cannot replace it directly, but we can create a new calculated column to meet your requirement:

 

ColumnName = SUBSTITUTE('Table'[ColumnToReplace],"OldText","NewText")

 

9.PNG

 


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Parent-part-is-not-showing-in-the-table-that-display-the-results.pbix
Message 2 of 2
825 Views

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

View All