This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Wise Owl Blogs - Home (page 16 of 25)

Showing blogs 301-320 (out of 487)

Errors when you delete a primary key in Power BI

Posted by Andy Brown on 22 February 2021

Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.

Tags:
Power BI > Measures / DAX

Having fun with online Teams meetings

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 ...

Tags:
Training > Online training

Building a word search system in Excel VBA

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!

Tags:
VBA macros > General

Using the WOWSER Excel VBA system to build a word search

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!

Tags:
VBA macros > General

How to use DAX to show for each row of a table its share of the maximum value

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.

Tags:
Power BI > Measures / DAX

Using a DAX query to show a table in Power BI

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!

Tags:
Power BI > Measures / DAX

What Power BI report server is, and how to create reports through it

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!

Tags:
Power BI > General SSRS > Report Manager

Creating and using Lambda Functions in Excel

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!

Tags:
Excel > Formulae

Did you know you could use your browser as a text editor? Us neither ...

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.

Tags:
Miscellaneous > Random musings

How to add cumulative totals to a visual using DAX measures in Power BI

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!

Tags:
Power BI > Measures / DAX

Playing the Harry Potter escape room game in Power BI

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).

Tags:
Power BI > General

Was Roger Hargreaves predicting the future of the US with his Mr Men series?

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!

Tags:
Miscellaneous > Random musings

Two easy ways to create themes in Power BI without needing to write JSON

Posted by Sam Lowrie on 30 October 2020

This blog show two ways in which you can create custom themes in Power BI without needing to learn how to write JSON: either use the built-in theme editor in Power BI, or use the theme generator from Power BI Tiips.

Tags:
Power BI > General

This blog shows you how to connect to Remote Desktop if you're using a Mac

Posted by Sam Lowrie on 30 October 2020

Most people attending our online training courses use Windows computers, but the odd Mac user slips through! This blog explains how you can connect to Remote Desktop on a Mac, and so still enjoy your Wise Owl online training.

Tags:
Training > Online training

The Power BI app for HoloLens 2 allows you to juggle futuristic 3D reports

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!

Tags:
Power BI > General

What happens when you blend the pieces from two different jigsaws?

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.