Forum Discussion
Feature Request: Add conditional column WITH data type
Dear Team,
I think it would be helpful if it was possible to set the data type for a newly inserted conditional column directly in the wizzard that helps to set the conditions.
Currently, "Add Column" -> "Conditional Column" will create a line of M like this:
GateInEmpty = Table.AddColumn(Source, "GateIn Empty", each if [GATEIN_DATE] = null then true else false),
Then we can either
- add a new step to change the type of the column
- edit the M code in the formula bar or advanced editor to achieve a result like this:
GateInEmpty = Table.AddColumn(Source, "GateIn Empty", each if [GATEIN_DATE] = null then true else false, type logical),
In daily usage, I like to avoid the extra step, especially because i can't remember the m code for the types by heart, i always have to keep a short list in OneNote to look it up and copy & paste from there:
, Int64.Type |
, type date |
, type logical |
So i think it would be nice to have a small dropdown menue in the conditional column wizzard to add the data type for the new column.
What do you think?
Best Wishes
2 Replies
I can already see datatype option there https://docs.microsoft.com/en-us/powerquery-m/table-addcolumn
Table.AddColumn(table as table, newColumnName as text, columnGenerator as function, optional columnType as nullable type) as table
does that not serve purpose
Dear amitchandak,
Thank you for your reply.
I am aware that i can define the data type in the M query directly.
However I normally use the add conditional column feature from the Power BI GUI instead of writing the code by myself.
I would wish for this GUI window to have a data type selection option so that it can write the code accordingly for me automatically:
