POWER BI BLOGS
POWER BI BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Measures / DAX in Power BI
Showing blogs 1-12 (out of 12)
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.
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!
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!
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 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!
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 13 June 2018
Learn about the perils of changing the cross filter direction to "Both", then discover why the CROSS FILTER function is better!
Posted by Sam Lowrie on 01 June 2018
How you can combine the use of measures and cards to create dynamic report headers in Power BI Desktop.
Posted by Sam Lowrie on 18 May 2018
Learn to use the SUMMARIZE and CALCULATE functions to produce numeric and weighted distributions.
Posted by Andy Brown on 08 June 2017
You can't drag and drop measures between tables, but there is an easy way to move them in Power BI Desktop, as this blog shows
Posted by Andy Brown on 19 December 2016
There are a host of date-based functions in Power BI Desktop for producing cumulative figures, but how do you get running totals for non-date columns? This blog explains!