Wise Owl Training - Power BI blogs (page 6 of 7)

Showing blogs 101-120 (out of 126)

Using the new Power BI template app to view Google Analytics data

Posted by Andy Brown on 20 September 2019

How to create a new app to view your Google Analytics data in Power BI Service.

Tags:
Power BI > Data sources

We have unearthed two new sources of information on future Power BI features

Posted by Andy Brown on 14 August 2019

In addition to the Power BI preview features dialog box, Andy Gould has discovered two excellent new sources of information on forthcoming changes for Power BI, as this blog explains.

Tags:
Power BI > Updates

How to view the SQL query for a series of transforms in Query Editor

Posted by Andy Brown on 02 July 2019

Did you know that you can view the SQL for a query in Power BI's Query Editor? Me neither!

Tags:
Power BI > Query editor

Creating complex custom date periods in calendar tables using calculated columns

Posted by Sam Lowrie on 15 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.

Tags:
Power BI > Dates and calendars

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

Posted by Sam Lowrie on 15 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.

Tags:
Power BI > Dates and calendars

Modelling a fixed or variable custom financial year in Power BI

Posted by Sam Lowrie on 15 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.

Tags:
Power BI > Dates and calendars

Getting Started with Power BI Report Server

Posted by Andrew Gould on 07 July 2023

Power BI encourages you to publish reports to an online service so that you can share your beautiful reports with the world. If you'd rather keep them a secret you can use Power BI Report Server to deploy your reports to an on-premises server, as this blog series shows you.

Tags:
Power BI > General Power BI > Power BI Service

The mysteries of context transition explained

Posted by Sam Lowrie on 22 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 29 January 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 25 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

Creating reports in Power BI with dynamic measures or dynamic dimensions

Posted by Andy Brown on 03 January 2019

This blog shows how to create fully dynamic reports, whereby users can choose which statistics to show and which dimensions to report them by.

Tags:
Power BI > General

Showing the top N values of a dimension, where you can use a slicer to vary N

Posted by Andy Brown on 06 December 2018

Following a question from a Power BI course, this blog shows how you can get a page to show the top N customers by sales value, where N is a number controlled by a slicer.

Tags:
Power BI > Measures / DAX

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

Posted by Sam Lowrie on 05 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!