The ALL function is an extremely important part of the DAX language in Power BI. It can be used in a number of different ways within formulas that allow you to calculate results seamlessly when combined with the filtering available in the data model. Simply put, the ALL function can remove any context that is
Category: Data Visualization
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
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.
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.
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