Solving a Complex Time Problem In Power BI

I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window. Think of it a bit like Rolling 12 Months Sales, or average weekly sales over a rolling 4 week period, but instead this problem uses a rolling time window of just a few hours. I have decided to demonstrate how to solve this problem using my own solar electricity data and build a rolling average 3 hourly kWh consumption.

Source : Excelerator BI
Read more…

How To: Use Jobs and Work Type Codes to Control Job Costs and Prices in Microsoft Dynamics NAV or Business Central

In Microsoft Dynamics NAV or Business Central, you can use work type codes to control your job costs and prices. On the Resources card, you can have a general rate for the resource, but for the work type, you can control the rate based on a state they work in or the type of work they do or other variation.

Source : ArcherPoint
Read more…