I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including:
Tag Archives: Date
How to Use Date Functions in Microsoft Dynamics Business Central On Premises
There are various places throughout Microsoft Dynamics 365 Business Central where you can enter dates in fields. In fact, a good deal of data in the application is linked to dates. For example, in a sales order, you can set the shipment date. When filtering lists or report data, you can enter dates and times to pinpoint only the data you want to see. If you look at a sales order, an invoice. or a credit memo, there are document dates, posting dates, and date of entry.
Show the refresh date\time in a Power BI report and dashboard
A short post today. Someone recently asked me: “How can I show the date and time this data has been refreshed last in my report and dashboard?”. Here are 2 simple tricks to help you visualize this.
Creating a Date Table in Power BI
Learn how to create a calendar or date reference for your data and organize it by building a DAX date table in Power BI.
Use of Virtual Table : Date – Microsoft Dynamics NAV
This blog post is about something powerful but hidden within Microsoft Dynamics NAV. I believe many developers always work with dates over and over during their day-today life and i’m sure many of you have done many functions which convert, split and do all sort of things with date.
Microsoft Dynamics NAV: How to Use Purchase Order Dates
Date fields on Microsoft Dynamics NAV sales and purchase orders can be confusing but very beneficial if used correctly. The dates are designed to allow you to:
•Schedule shipment in time to meet the customer’s requested delivery date.
•Schedule the receipt of product in time to ship the order on the desired date.
•Track your vendor’s delivery performance.
How to Use Sales Order Dates in Microsoft Dynamics NAV
Date Fields on Microsoft Dynamics NAV sales and purchase orders can be confusing, but very beneficial if used correctly. The dates are designed to allow you to:
•Schedule a shipment in time to meet the customer’s requested delivery date.
•Schedule the delivery of a product in time to ship the order on the desired date.
•Track your delivery performance to your customer.