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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
49 | |
45 | |
38 | |
37 |