Sometimes a situation comes were NAV Job stops and we keep on debugging but yet unable to stump the real cause. Even after continuously tracing in Event Viewer we dint found any solid reason for this. So to solve my scenario I decided to write a SP(Stored Procedure) which eventually I attached it as a SQL Job which is supposed to be one of the best scheduler in Programming World.
One very common requirement when creating a Power BI report is the ability to apply a filter for the current day, week, month, quarter or year. There are several ways of implementing this: you could add relative date columns to your Date table as I show here (I used DAX calculated columns but you could also do this in M quite easily too); you could also build the filter into the DAX for your measures, although that could mean you end up with a lot of quite complex measures.
I admit .. this is somewhat late in the year to come with this information. But I was searching for marketing material on NAV2016, and came across a list of links to (mainly) PartnerSource that might be useful for you as well, so I decided to write up a quick blogpost.
As such, these are “official” resources for NAV 2016, regarding three topics: