Power Query often automatically adds a ‘Change Type’ step after loading data to try and assign data types to columns based on the first 1,000 rows. If your data includes inconsistent types, such as ...
So I've got this large dataset...call it t_Data, it's pretty easy to cut it up with a where condition in LINQ, but I want to be able to interrogate another dataset....call it q_Category (which ...