Posted by
Andy Brown
on 02 February 2021
Did you know that you can apply Snapchat filters to your Teams background? Or show a test card? Or send customised stickers? Read this blog to find out more ...
Posted by
Andy Brown
on 02 February 2021
My aim in this blog is to show how you can go about building any computer system from scratch (and not just a word search in Excel VBA). Along the way I've included lots of hints and tips!
Posted by
Andy Brown
on 01 February 2021
Follow this blog to construct your own word search, complete with a missing phrase spelt out by the unused letters!
Posted by
Andy Brown
on 22 January 2021
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.
Posted by
Andy Brown
on 14 January 2021
Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!
Posted by
Andy Brown
on 23 December 2020
Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!
Posted by
Andy Brown
on 21 December 2020
You can now create and use anonymous functions in Excel (usually called "Lambda functions"). Learn how to add to the stock of Excel functions without having to learn any programming code!
Posted by
Andy Brown
on 02 December 2020
Thanks to Simon Ranson for contributing this bit of trivia: what to type into your browser's address bar to turn it into a text editor.
Posted by
Andy Brown
on 02 December 2020
Inspired by a question from a course, in this blog Andy Brown builds up a measure to show cumulative totals for a calendar matrix, dotting his DAX i's and crossing his t's!
Posted by
Andy Brown
on 27 November 2020
This awesome game shows what's possible using bookmarks in Power BI (think of it as the sequel to Sam's 2019 Pin the Tail on Rudolf game).
Posted by
Andy Brown
on 26 November 2020
There's an uncanny correlation between the Mr Men series and the list of American presidents. Donald Trump comes in as Mr Rude, Barack Obama as Mr Cool … see how many correlations you can find!
Posted by
Andy Brown
on 24 October 2020
What do you get when you combine the futuristic 3-dimensional mixed-reality environment created by the HoloLens 2 headset with Power BI reports? Read this blog to find out!
Posted by
Andy Brown
on 24 October 2020
Vancouver-based artist Tim Klein has used the fact that many jigsaws are based on the same template to create some truly weird and wonderful composite images.
Posted by
Andy Brown
on 24 October 2020
Following a question from a recent DAX course, here are 3 recommended YouTube tutorial channels to help you learn to master DAX.
Posted by
Andy Brown
on 24 October 2020
The new Excel LET function lets you create variables to store the results of calculations, making formulae easier to read and quicker to calculate.
Posted by
Andy Brown
on 26 September 2020
Power Apps is fun, as this blog tries to show. It consists of one owl's very personal take on the 5 best things about using the software.
Posted by
Andy Brown
on 26 September 2020
Any software has things you love, and things you ... don't love so much. This blog covers the latter set of things!
Posted by
Andy Brown
on 24 September 2020
The XLOOKUP function has at least 7 advantages over an equivalent VLOOKUP function, as this blog shows. Convert to XLOOKUP now, and then convert your colleagues!
Posted by
Andy Brown
on 19 September 2020
This blog shows a simple way to export a Power Apps app without creating a solution. If you've got a fairly simple app without too many resources or data sources, it describes a much easier way to back up and restore apps than the standard export/import approach.
Posted by
Andy Brown
on 25 August 2020
You can have great fun taking your favourite image (a picture of your loved one?) and pixellating it in VBA. The results are stored as RGB numbers in a workbook - what you do with them then is up to you!