The function Table.SelectRows is a very common power query function that is used to filter a table. It is what is created when you filter rows in a table using the UI. It takes a table and then applies whatever filters are set in the second argument. The following code generates Read more…
This appears to have changed since I posted this and now it will query fold when types are changed in either manner. I recently found this trick to improve folded queries when changing data types. It allows you to do type changes of columns without breaking the query folding. You Read more…
So I just took the 70-778 exam online, and I passed! I obviously can’t say what was on the exam but I will say a few thoughts I had about the preparation for and process of doing the exam itself. In terms of preparation 80-90% of what prepared me was Read more…
This Power BI Report was created for the fourth London Power BI User Group [PUG] challenge. This is the second time I have done this challenge but the first…