Power Query Functions need strong RETURN DATA TYPES, not un-typed columns
This one has bothered me for a while. Why do Power Query Functions not have a Return Data Type like functions in C# and VB and T-SQL and just about every other coding language? For example, take the function Text.Combine. It combines multiple columns (which, by the way, must be of type TEXT) but...
STATUS
DETAILS
New
Edit Relationship dialog box, need to sort columns consistently
Column order in a table really does not matter, but most designers put their key columns at the top, then other important columns below that, and generally speaking in order of importance. One rarely finds highly important columns at the end of the table definition. It was with a little disappoi...
STATUS
DETAILS
New