Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
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:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
70 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |