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.
Category: Business Intelligence
The Natural Language Query capability in Power BI is amazing. There is so much you can discover just by writing these Google-like queries inside of the search bar and dashboards in Power BI online. After you view and go through this tutorial, I think you’ll be amazed at how advanced you can get with Natural Language
In this advanced video tutorial which is a breakout of a budgeting workshop that was part of the Enterprise DNA webinar series, I am going to run through how you can utilize some advanced functions inside of Power BI like CALCULATE, ALLSELECTED and SUMMARIZE. By using all the functions in combination we are able to
We’re going to get advanced today around budgeting in Power BI. Occasionally, you will not actually have some unique budgeting or forecasting data and you need to create it. Most forecast or budgets will likely be created based on historical results in some way. You might do something very simple, like finding the results from
Here I want to dive in a real world application of Power BI – How can we discover how much profit are we missing out on? There are probably a few ways that you could work out solutions to this. The way I have done it with this example is to focus in on margin