User Profile
sperry19
New Member
Joined 3 years ago
User Widgets
Contributions
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 transform the column into a date. Here is the code where the error occurs. in Source, #"Extracted Date" = Table.TransformColumns(CMSales,{{"CREATED_DATE", DateTime.Date, type date}}), #"Filtered Rows" = Table.SelectRows(#"Extracted Date", each ([STATUS] <> "CANCELLED")), CREATED_DATE = #"Filtered Rows"{0}[CREATED_DATE] Any advice appreciated.
