Forum Discussion
Can you change data format in direct query?
i am tyring to change the data format in direct query but unable to do so how do i go about changing something to a text data format without being able to create calculated columns or use the data format part?
16 Replies
- Greg_Deckler
Community Champion
No, love the user name.
Greg_Deckler thank you so how would i fix the following calculation;
CALCULATE(COUNT(Product[Name]),FILTER(table1,table1[SalesUnits]>0),ALLEXCEPT(table1,table1[country]))as currently it is saying i am unable to do this;- Greg_DecklerI think COUNTA ?
- amitchandak
Super User
Anonymous , I was able to change the data type from number to text.
I changed the data type of year
amitchandak & Greg_Deckler i do not have an opption to change the data type or format. Its not something i can edit it is currently set to teext for the field that is not working please see example below;
- Greg_Deckler
Also, this is very odd, COUNT specifically says it supports Strings.
