cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
spagad6263
Helper V
Helper V

How 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

 

spagad6263_0-1665689360235.png

 

1 ACCEPTED SOLUTION
Dinesh_Suranga
Responsive Resident
Responsive Resident

@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.

Dinesh_Suranga_1-1665692850848.png

If this reply solved your problem, Please accept this as the solution.

Thank you

View solution in original post

2 REPLIES 2
spagad6263
Helper V
Helper V

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

Dinesh_Suranga
Responsive Resident
Responsive Resident

@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.

Dinesh_Suranga_1-1665692850848.png

If this reply solved your problem, Please accept this as the solution.

Thank you

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors