Category: Data Visualization

Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX

One thing that can seem like a limitation of Power BI is its calendar date table. Often, you’ll need to calculate results across a custom financial year, but only the standard date table is available. You may initially think that you need a new date table, but you don’t. You can use DAX in either

Continue reading

Learn How To Harvest Power BI Slicer Selections To Use Within Other Measures

When using Power BI you sometimes think you are limited to the data sitting within your tables. Well with Power BI that is certainly not the case. You have tremendous flexibility to build on top of your data by bringing in values from additional tables to flex the numbers or stress your results with scenarios.

Continue reading

The DATEADD Function. The Best And Most Versatile Time Intelligence Function in Power BI

The DATEADD function is by far my go to time intelligence function in DAX at the moment. Mainly because of it’s immense versatility to generate time comparisons over a range of different time frames. This detailed video will go through all the various aspects of how to set up time comparison analysis with this function.

Continue reading

Discover How To Repeatedly Project A Current Trend Forward In Power BI

In this unique example, I want to show you how you can take a historical trend and repeatedly project it forward. This particular example came to me from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world. They had to take historical

Continue reading

Deep Dive Into The CALCULATETABLE Function – An Important DAX Formula To Understand Well

The CALCULATETABLE function is an incredibly important DAX function to learn and understand well. Most of you who are just starting out with Power BI, have probably glanced over this particular function (I certainly did when I first started out using Power BI and writing DAX measures). It’s quite a complex function to understand and

Continue reading