Forum Discussion
sperry19
3 years agoNew Member
Table.TransformColumns issue
Hi All, I'm trying to fix up a report that stopped working for whatever reason, I do not have much experience with power query and am stuck. The problem is I get the error below when trying to tr...
- Anonymous3 years ago
Hi sperry19 ,
Try to split the conversion into two steps.
#"Changed Type" = Table.TransformColumnTypes(CMSales,{{"CREATED_DATE", type datetime}}), #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"CREATED_DATE", type date}})Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum