Steven Kienle on 06 Apr 2022 12:54:59
M lets you set the data type on several functions, for example Table.AddColumn. But when using the dialog to create or modify a column, you cannot set the data type. This means we have to create the column, then edit the M code to specify the data type. On the positive side, that change does not stop the use of the dialog. But if you edit the column using the dialog, the data type can be lost.
The best solution to this would be to add a data type dropdown to every Power BI dialog whose underlaying M function allows for the data type argument. This will not only reduce steps for power users, but also open up this option to new and casual users as well.