Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
User | Count |
---|---|
120 | |
67 | |
66 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |