Forum Discussion
Post PatronHow to change Data Type after a Date table is created?
Hi, I've created a local Date table using DAX. I would like to change the data type for a few column. In Power Query Editor, I can't see this calculated table. Is there a way I can view and change the data type for a calculated table? Thanks
Hi.
You can not see tables in power query editor which you have created using DAX formula. But you can change data format without power query editor.
1 Go to table view
2 Select colum you want to change the data type from your right side panel.
3 Change data type.
If this reply solved your problem, Please accept this as the solution.
Thank you
2 Replies
spagad6263Perfect, and this is exactly what I want. Thanks so much for the quick reply. Have a good weekend!
- Dinesh_Suranga
Continued Contributor
Hi.
You can not see tables in power query editor which you have created using DAX formula. But you can change data format without power query editor.
1 Go to table view
2 Select colum you want to change the data type from your right side panel.
3 Change data type.
If this reply solved your problem, Please accept this as the solution.
Thank you