Prepare for Year-End: Dynamics 365 Business Central Operations Calendars

By admin in Dynamics NAV & BC, Tips & tricks

In this video, we delve into crucial year-end procedures essential for the operations team using Microsoft Dynamics 365 Business Central.

For those currently employing Production in Work Centers, ensuring that your work centers are configured with accurate shop calendars and scheduled capacity is vital. Failure to calculate the capacity and availability for the upcoming year might lead to complications such as errors during MRP or MPS operations, impeding production scheduling within Business Central.

Source : ArcherPoint
Read more…

Adding Semesters to a Calendar in Power BI

By admin in Data & Analysis

I have delivered Power BI training at a number of universities over the last 6 months, and a few of the participants asked me the same question. “What is the best way to add semesters to a calendar so that they can analyse student data by semester?“ There are various ways of solving this problem. In this article I want to share with you one way to solve it using DAX in Power BI. I will use AdventureWorks database for the demonstration.

Source : Excelerator BI
Read more…

Toggle Overlapping Time Periods using the Calendar Table

By admin in Data & Analysis

I had a great question pass my way last week while I was at the Microsoft Business Application Summit. The problem presented by Matt (a different Matt, not me) was that he had around 200 measures already written, but wanted to be able to toggle the report pages between YTD and Full Year data. For the sake of this article I will be using Year to Date (YTD) and Moving Annual Total (MAT) as the 2 toggle events.

Bron : Excelerator BI
Lees meer…

Build a Reusable Calendar Table with Power Query

By admin in Data & Analysis

I wrote a blog on this topic a few years ago over at PowerPivotPro.com. I have learnt a lot about Power Query since that time, plus Power Query has come along in leaps and bounds, and it now has a lot more capability than it had previously. Today I am going to write a new post showing you how to build a reusable Calendar Table using Power Query.

Bron : Excelerator BI
Lees meer…

How calendars are considered when calculating lead times

By admin in Dynamics NAV & BC, Tips & tricks 0 Comment

Lead time calculation is the calculation that takes place to calculate “Expected Receipt Date” from the “Order Date” or the other way around. Similarly, sales have the calculation to calculate “Planned Delivery Date” from “Shipment Date” or the other way around as well. Here, we will be focusing on the Purchase side but this will have same explanation for the Sales.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…