I’m hearing you already say: “Natalie, a whole blog post about the stupid times? Are you kidding me, or do you want to waste my time, and yours?” – No, quite on the contrary! But after 17 years doing C/AL and AL, even I’ve just learned new details about it, so maybe you can learn something new as well
Tag Archives: TIME
Creating a Time intelligence “External Tools” app for Power BI Desktop
With the release of the July 2020 version of Power BI desktop we can create tools that can interreact with the Power BI Desktop model directly using an external tool. With this interaction you can make changes to the model in a programmatic way. There are so opportunities things this will open up. You can think of a tool that would allow you to edit the model like Tabular Editor or query like DAX Studio (which both already work as external tools).
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.
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.
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.
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.
Time intelligence solved with modelling and crossfilter instead of DAX measures
A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through the model. The pattern was created by the great Greg Galloway from Artis Consulting and I am blogging this with his permission.