TIME – Pardaan.com

Times in BC – you didn’t know that!

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…

17 November 2023

Data & Analysis

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…

20 July 2020

Data & Analysis

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…

27 September 2019

Dynamics NAV & BC Tips & tricks

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…

18 June 2019

Data & Analysis

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…

17 June 2019

Data & Analysis

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. Bron : Kasper On BI Lees meer...

19 December 2018

Data & Analysis

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…

14 December 2018