The Order You Select Columns In The Power Query Editor Can Affect The Output Of Some Transformations

Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the output of certain transformations.

Bron : Chris Webb’s BI Blog
Lees meer…

Extending the Outlook Add-in Experience in Microsoft Dynamics 365 Business Central and Microsoft Dynamics NAV

One of the showcase features of Dynamics 365 Business Central is the ability to use the product within Microsoft Outlook clients using Outlook add-ins. There are two add-ins that come out of the box with Dynamics 365 Business Central: The Contact Insights add-in and the Document View add-in.

Bron : Dynamics NAV Team Blog
Lees meer…

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 want those, you will have to create the calculations yourself.

Bron : Dutch Data Dude
Lees meer…

Cost Roll Procedure in Microsoft Dynamics NAV

The information below explains the steps to follow while rolling standard costs in Dynamics NAV. The process is relatively simple, but the goal of this document is to explain the importance of each step: and what is accomplished in those steps. So while this may appear to be a long blog, stick with is as it provides a thorough explanation and rationale of each step.

Bron : ArcherPoint
Lees meer…

Docs for Dynamics NAV 2016 and earlier are now on Docs.microsoft.com

For almost 10 years, you might have become used to finding content online for Dynamics NAV in the MSDN Library. We announced last year that we’re moving to the Docs.microsoft.com site, and today we moved the last bits to the Docs site as well.

Online content for Microsoft Dynamics NAV 2016 and earlier versions of Dynamics NAV is now available in the Previous Versions section of the Docs site.

Bron : Dynamics NAV Team Blog
Lees meer…