10 reasons why Python is better than C# (or almost any other programming language)

After resisting learning Python for years, assuming it was just another object-oriented programming language, Andy Brown now gets what the...

Creating Time-Intelligence Functions in DAX

DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in...

Using Calendars and Dates in Power BI

You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages...

Cracking DAX – the EARLIER and RANKX Functions

So far in this series, Andy Brown of Wise Owl Training has shed light on functions like CALCULATE, VALUES and...

Using the FILTER Function in DAX

In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE...

Using the DAX Calculate and Values Functions

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how...

Creating Measures Using DAX

In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the...

Creating Calculated Columns Using DAX

In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as...

Moving Data From Excel to SQL Server – 10 Steps to Follow

SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates...

10 Reasons Why Visual Basic is Better Than C#

After having converted a whole lot of training materials based on VB.NET into C#, Andy 'Wise Owl' Brown decided to...