A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through the model. The pattern was created by the great Greg Galloway from Artis Consulting and I am blogging this with his permission.
While Power BI has a lot of great functionality for filtering the data that appears in a visual using visual-level filters there are going to be situations where you need more control over how filtering works, and in this blog post I’m going to show you how you can use visual-level filters and measures in combination to achieve this. The example I show here may be quite specific but I think the general technique has a lot of other interesting applications.
If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations. For example, here’s a screenshot from Power BI Desktop in DirectQuery mode with a measure where I’m trying to use the RankX() function:
Microsoft Dynamics NAV is very flexible when it comes to setting up Units of Measure for items. But careful consideration should be used before setting up the Base Unit of Measure. Once the Base Unit of Measure is established and there are transactions recorded for the item, the Base Unit of Measure cannot be changed.
Times are tough and poor Gru has gathered all the minions together to inform them that production on new minions has to stop and a full reconciliation of component parts has to be done. The Minion factory is shutting down. Current Sales orders will be fulfilled and then the machines will lie dormant.
It is quite common in processing industries, like chemical production, that the cost of Labor is not the primary cost of production. In chemical processing, the cost of energy or depreciation may be the largest cost component.
While Centers and Routings in Dynamics NAV are typically thought of in terms of Direct Cost (Labor) and Overhead, we can set up Work Centers and Routings to accommodate other cost components.