Posted by
Andy Brown
on 13 February 2020
Simple Talk provide excellent how-to guides on any aspect of Microsoft software. We are proud to have contributed a series of articles explaining how to create DAX calculated columns and measures within Power BI.
Posted by
Andy Brown
on 10 January 2020
When we find new features which we didn't know about, we try to share them! Did you know that you can turn preview off when getting data? Or that you could left-click to drill-through? We didn't!
Posted by
Sam Lowrie
on 08 November 2019
This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.
Posted by
Sam Lowrie
on 28 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!
Posted by
Andy Brown
on 18 October 2019
Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.
Posted by
Andy Brown
on 20 September 2019
How to create a new app to view your Google Analytics data in Power BI Service.
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.
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!
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.
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.
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.
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.
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.
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!
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!
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.
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.
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!
Posted by
Sam Lowrie
on 30 July 2018
Learn to use DAX variables, and understand how they can be used to break up code. Not true debugging, but better than nothing!
Posted by
Sam Lowrie
on 18 July 2018
Some technique to remind users what levels they chose while using drilldown.