Power BI Custom Format String Examples, Part 2: Dates And Times

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.

Source : Chris Webb’s BI Blog
Read more…

Setting Up and Using Time Sheets in Microsoft Dynamics NAV 2018

For companies that use Microsoft Dynamics NAV and have employees who need to track time against a job, for service, or for HR, there is a feature that does not typically get attention during the initial implementation or if your company is growing. This blog explains how to set up and use the Time Sheets feature in Microsoft Dynamics NAV 2018.

Source : ArcherPoint
Read more…a>

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…

Toggle Overlapping Time Periods using the Calendar Table

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…