How to change Data Type after a Date table is created?

[spagad6263]

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

[spagad6263]

Perfect, and this is exactly what I want. Thanks so much for the quick reply. Have a good weekend!

[Dinesh_Suranga · Accepted solution]

@spagad6263 ,

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