TIME – Page 2 – Pardaan.com

Smart Solutions 7: Predictive analysis with Time Series, and intro to R for C/AL developers

Time Series is a topic on its own in machine learning, as it is one of the cleanest examples of predicting the future. All you need is a dataset that contains a date and a number. Time Series then uses this to predicting values for future…

3 September 2018

Data & Analysis

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…

9 August 2018

Data & Analysis

Time Intelligence Using DAX

Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence. This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below). Bron : Excelerator…

12 June 2018

Dynamics NAV & BC Tips & tricks

How to restrict an action button based on time in Microsoft Dynamics NAV

The requirement was such that on click of the action button a payment transaction is done. The time at which transaction was done is stored in the database. A restriction shouldto be applied to disallow the customer to make payment for the same amount till a…

2 May 2018

Data & Analysis

Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)

Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I used two-month periods in my example below). If you…

17 April 2018

Data & Analysis

Daylight Saving Time And Time Zones In M

Quite a few people (Ken Puls, Reza Rad and today Chris Koester) have blogged about how the M date/time zone functions work in Power Query/Power BI, and the related problem of turning a UTC time into the actual time in any given location taking Daylight Saving…

4 April 2017

Dynamics NAV & BC Tips & tricks