Wise Owl blogs written by Sam Lowrie (page 1 of 2)

Showing blogs 1-20 (out of 34)

Writing an App in Power Apps

Posted by Sam Lowrie on 26 June 2020

Sam was tired of getting told off for crinkled or missing expense receipts. So he had a look at Power Apps and this is what he found…

Tags:   Power BI | General

Use VBA to create Microsoft Team meetings

Posted by Sam Lowrie on 26 June 2020

Did you know that you can create Microsoft Team meetings using VBA in Outlook? This blog shows you how!

Tags:   VBA macros | General

5 things Sam has done while locked inside!

Posted by Sam Lowrie on 26 June 2020

Our trainers are normally out and about across the entire UK (even Europe sometimes). So what has one of them been doing with all this extra time at home?

Tags:   Musings | Random musings

FAQ - questions (and answers) about how our online training works

Posted by Sam Lowrie on 19 June 2020

This blog answers some of the frequently asked questions about how our online training works (such as what software and hardware you'll need, and what freebies are included!).

Tags:   Musings | Online training

How to configure your webcam, microphone, speakers and much more!

Posted by Sam Lowrie on 19 June 2020

Not sure what you need for our online courses? Here's our definitive guide to setting up your computer sofware and hardware to ensure that everything works smoothly.

Tags:   Musings | Online training

The Wise Owls have new home offices (with some better than others ...)

Posted by Sam Lowrie on 07 April 2020

The Coronavirus crisis has made the Wise Owls flee to their home nests - but as this blog shows, some nests are better prepared than others.

Tags:   Musings | Random musings

Sam attended our first Power BI meetup at the end of January, and was impressed!

Posted by Sam Lowrie on 29 February 2020

A summary of what happened in the Power BI meet-up at the end of January, from a convert (Sam).

Tags:   Power BI | General

YouTube Silver Award - 100K + subscribers!

Posted by Sam Lowrie on 25 November 2019

We're proud to announce that YouTube have given us their coveted silver award, in recognition of the fact that our video channel has over 100,000 subscribers.

Tags:   Musings | General IT

Dynamic comparison calculations in DAX

Posted by Sam Lowrie on 11 November 2019

This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.

Tags:   Power BI | Measures / DAX

Explaining the VALUE argument of the RANKX function in DAX

Posted by Sam Lowrie on 29 October 2019

The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!

Tags:   Power BI | Measures / DAX

5 board games worth trying

Posted by Sam Lowrie on 05 October 2019

Sam lists out 5 board games you should try, covering everything from matching symbols to killing zombies.

Tags:   Musings | Random musings

Attending an Expo - 5 things to consider

Posted by Sam Lowrie on 19 August 2019

Having attended our first expo we would like to share some insights into things to consider!

Tags:   Musings | Exhibitions

New features introduced in the July 2019 update of Power BI

Posted by Sam Lowrie on 02 August 2019

There are big changes to conditional formatting this month (you can display icons, and use percent-based thresholds), but the biggest change of all is the release - finally - of the new filter pane.

Tags:   Power BI | Updates

Creating complex custom date periods in calendar tables using calculated columns

Posted by Sam Lowrie on 17 May 2019

This blog shows how to create custom date periods within a date table for 28 day cycles, but the principles shown could be applied to create any custom date periods.

Creating a calendar or date table in Power BI using built-in calendar functions

Posted by Sam Lowrie on 17 May 2019

Learn how to create a basic date table in Power BI, using either the CALENDAR or CALENDARAUTO functions, and also learn how to then add custom columns of your own.

Modelling a fixed or variable custom financial year in Power BI

Posted by Sam Lowrie on 17 May 2019

Whether your financial year ends on a fixed date every year or on the first Monday in June, this blog will show you how to incorporate it into your calendar table.

The mysteries of context transition explained

Posted by Sam Lowrie on 25 February 2019

Context transition happens when a DAX function creates filter context within row context, or vice versa. This blog explains what context transition is, and shows which DAX functions make use of it.

Tags:   Power BI | Measures / DAX

Understanding row context in DAX

Posted by Sam Lowrie on 01 February 2019

Row context (along with its sibling, filter context) is one of the most important concepts in DAX. This blog explains what row context is, and how to use it!

Tags:   Power BI | Measures / DAX

Understanding filter context in DAX

Posted by Sam Lowrie on 28 January 2019

Understanding filter context is the key to understanding how to create measures in DAX. This blog aims to explain this vital subject as succinctly as possible!

Tags:   Power BI | Measures / DAX

How to monitor stock levels from forecast sales using DAX measures in Power BI

Posted by Sam Lowrie on 06 November 2018

Given your current stock levels and forecast sales, it should be possible to report on future stock depletion in Power BI. This two-part blog shows you how to just that!

Tags:   Power BI | Measures / DAX
This page has 0 threads Add post