Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |