In my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two reasons: there are a lot more useful examples of custom date and time formats built into Power BI Desktop, and some of the format placeholders listed in the VBA documentation aren’t supported in Power BI.
Tag Archives: Date
How To: Use Sales Order Dates in Microsoft Dynamics NAV 2018
Date fields on NAV 2018 sales orders can be confusing, but used correctly, they will improve your sales order processing. The dates are designed to allow you to plan the shipments to meet your customer’s delivery expectations.
How To: Use Purchase Order Dates in Microsoft Dynamics NAV 2017
Date fields on NAV 2017 purchase orders can be confusing, but used correctly, they will improve your purchase order processing. The dates are designed to allow you to schedule the receipt of product in time to meet your shipment commitments and your customer’s delivery expectations.
Query by Example to Extract YYYY-MM from a Date Column
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:
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.