by Wyn Hopkins Why I Prefer Building Reports in Power BI I recently presented a session at the Global Excel Summit in London entitled “Why Power BI is better than Excel … or is it?” Tough crowd! My co-presenter Sue Bayes and I were up against our Unpivot co-hosts Giles Male and Mark Proctor [...]
by Wyn HopkinsThe Easiest Multi-Dependent Dropdown You've Ever Seen in ExcelIf you've ever needed row-by-row dependent dropdowns in Excel — where each row can have its own independent selection across multiple levels — you've probably found most solutions clunky, formula-heavy, or fragile. This one is different. And honestly? It might be the simplest approach you've ever seen. 🤔You might like to check out our Online Professional Excel [...]
by Melina Louzada Welcome to the world of streamlined efficiency with Excel Office Scripts! In this blog, we dive into the transformative power of automating your Excel workflows, specifically focusing on a scenario many of us encounter: managing and organizing current and completed records in an Excel file. Picture this... You have a list of [...]
by Wyn Hopkins The Challenge... In this month's challenge, you need to combine any non duplicate items into a single cell for each client ID#. e.g. Client ID1 has 2 rows. All entries need to be combined to return 1 row for Client ID 1 so for example the two Phone Numbers: Phone 1 and [...]
by Wyn Hopkins The Challenge... Download the file Thanks for taking part and here's our solution Submissions can still be viewed here.
by Wyn Hopkins The Challenge... School’s almost out for summer (well in Australia anyway)… how has everyone done in their exams? Who had the highest average score for each day? How can we tell? We need to sprinkle on some Power Query Magic dust! *Don't forget to make your solution flexible so that if more [...]
by Wyn Hopkins The Challenge... Our Solution... Convert Range of Values to a List - Power Query Challenge youtu.be Your Solutions... Some of the solutions we received can be viewed here along with the original challenge: Power Query Challenge Tickets to Rows
by Wyn Hopkins Creating a Merge Duplicates Alert This challenge is how to warn the end user that duplicates exist The Challenge... Take the challenge with our free download And if you would like us to have a look at your solution e-mail it to info@accessanalytic.com.au
by Wyn Hopkins The Challenge: Hours from Start and End Assume Start Time and Stop Time are always whole hours Solution must handle new rows of data being added to the source with new staff names Remove any records marked as "exclude" in the Status column (handle upper case / lower case typos) Our approach... [...]
by Wyn Hopkins The Challenge: Survey Response Remove any current AND FUTURE columns that begin with Sys, but allow for other future additional (non Sys) columns to be automatically included Replace all but 1 space between the names in the first column Add a TRUE / FALSE flag for the 3 response options in 3 [...]
by Wyn Hopkins Challenge: Change columns to a single row Inspired by a real-life scenario where nicely structure data needed to be "Pivoted", but in a specific way, and as always with Power Query it needs to work when new data is added. The challenge is to: present each person as a single row with [...]
by Wyn Hopkins Wordle for Power BI Fans We've updated the Wordle Game for all our Power BI Fans out there. All the words are related to Power BI in some way. Click on the file below to play along! *Word of caution though, the file won't open on iPhones. Download a copy of [...]
Contact us today to learn more about our Power BI training options
08 6210 8500
