Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Number to text in Direct query

Hi, I have a Numeric column which i want to convert to text using a formula. But When I try to use FORMAT function it dosent allow me as it dosent support direct query.   Thanks, Ravi
  • saileekumawat's avatar
    9 years ago

    As said earlier, you can do this in the at query level 

     

  • Phil_Seamark's avatar
    9 years ago

    What is your datasource?  If it's SQL you can just modify your query.