Filtering a Column via a Visual AND CALCULATE

Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you. Such events can cause you to doubt your own learning and progress. But let me assure you – this happens to EVERYONE at sometime or another. In this article I am going to show you one such baffling situation, and then explain what is really happening.

Bron : Excelerator BI
Lees meer…

How To Calculate Difference Between Two Dates in Navision 2013 R2 and Higher ?

It was always been a trouble to calculate Difference Between Two Date Time Variables.

With Microsoft Dynamics NAV 2013 R2, Dotnet Variable are available which make life easy in so many situations. Today we will discuss one of the Dotnet Component for calculation Difference between days.

Bron : Saurav Dhyani
Lees meer…

Walkthrough: Calculating Work in Process for a Job

With jobs, you can schedule the usage of your company’s resources and keep track of the various costs associated with the usage of resources on a specific project. Jobs involve the consumption of employee hours, machine hours, inventory items, and other types of usage that have to be tracked as a job progresses.

Bron : MSDN
Lees meer…