Captilize each word in Direct Query

[ak77]

Hi BI Gurus

i have a column say "Node Name"  which has multiple words(Ex: PRIVATE DEBT AND LOAN,DIRECTLY HELD INVESTMENTS etc) retrieved thru Direct query. 

i want to change it to Capitalize each word Private Debt And Loan, Directly Held Investments

i have tried below and it gives error that  the source should be converted to import mode before using it

1.Captilize each word in power query

2.m code Text.Proper(Node Name)

is there a way to achieve this in DAX .. Please pass the DAX sample if available when Direct query is used

Thanks

Ajay

[Ritaf1983 · Accepted solution]

Hi @ak77 
The problem with Dax here is that you can't add a column with direct query mode.
I don't think that there is a solution from power bi.
But,
You can modify it from the connection

In the datasource connection --> Advance options --> Specify the Select query. 

Example : select upper(colname) Col1, upper(colname) Col2 from table1,etc....

Please see linked discussion:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Format-a-field-to-Title-Case-when-us...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.