Top tips for Power Query Data Types

by Eric Marshall Assigning Data Types Assigning data types is an essential step when working with Power Query in Excel or Transform Data in Power BI Desktop. Here are some useful tips on how to change data types while maximising the efficiency of your models: Tip #1: Don’t Change Types Until the End of a [...]

Multiple Teams logins with Edge Chromium

by Wyn Hopkins How to handle teams when you have multiple different logins Often people are required to be part of "Teams" in organisations other than their own. The desktop app is OK at allowing you to switch between different organisations if you have the same email address for all teams. The trouble starts when [...]

2020-06-30T12:46:52+08:00Teams|

Tricking Non-Dynamic Array Formulas into Spilling

Tricking Non-Dynamic Array Formulas into Spilling by Jeff Robson   Tricking non-dynamic array formulas into spilling isn't something you'd naturally think of doing. Dynamic Arrays are great but sometimes the formulas that refer to them behave in unexpected ways, and sometimes these don't spill ... without any obvious reason. For example, the DATE function spills, [...]

2020-07-02T12:43:16+08:00Arrays, Functions|

Excel tips & tricks to boost productivity

by Wyn Hopkins Boost your productivity with these shortcuts With over 20 years' experience in Excel we've picked up a few tips and tricks. We'll show you the shortcuts, features and formulas that will speed up your daily use of Excel. From SWITCH to Dependent Drop downs,  Grouping to Conditional Formatting,  clever validation lists and [...]

Connect to files stored on OneDrive and SharePoint

by Wyn Hopkins How to use Power Query to connect to a file on OneDrive or SharePoint A growing number of organisations are starting to store their files on OneDrive for Business and SharePoint. Users will begin to discover that connecting to these files with Power Query is not as straight forward as clicking the button for [...]

Hard coded data sources in Power BI

By Eric Marshall Hard coded data sources in Power BI Simple, hard-coded data tables can be useful data sources in Power BI (provided your data won’t change!). Here’s how to incorporate hard-coded data into your data model: Under the Home ribbon of Power BI Desktop, click “Enter Data”.   Double click on “Column1” and rename [...]

2020-04-21T13:34:25+08:00Power BI|

Power BI & Excel Virtual Classroom

Virtual Classroom - Power BI & Excel We're 100% still open for business and set up to deliver our highly rated Power BI and Excel "in - person" training via the magic of the internet! This is great, as not only do Perth clients continue to get access to our training courses, folks around Australia [...]

Corkscrew Calculations using Dynamic Array Functions

by Jeff Robson Corkscrew Calculations using Dynamic Array Functions If you've come to this page expecting information about how to open your wine bottles, you're going to be very disappointed!  Sorry! The corkscrew calculations we're talking about here are those you'd use when calculating a balance sheet account in a financial model. Accounts Receivable Example [...]

The Rise and Fall of the escalation formula

By Robert Hind Does your contract Rise and Fall let you down? When you're providing products or services in a long term relationship there is usually a contract which will typically include an Escalation (Rise and Fall) formula. The intent of the Escalation Formula is that cost increases or decreases should be passed on so [...]

Share This