Change data type @ ExpandTableColumn

[Anonymous]

Hi

Just to reduce the number of steps, can I change the data type for column "Since" to date at this step by the following code:

Originally it is a date but changed when grouped.

Table.ExpandTableColumn(#"Added Custom1", "Index", {"OPEN_AREA", "Block", {"Since", type Date}, "Max"})

The above returns error for me!

[cpwebb]

The code above returns an error because Table.ExpandTableColumn doesn't support setting data types in this way: the third parameter takes a list of column names, not a list of column names and data types.

I blogged about another way to solve this problem here: https://blog.crossjoin.co.uk/2017/09/25/setting-data-types-on-nested-tables-in-m/