Dynamics NAV Coffee Break: How to Personalize Columns in Dynamics 365 Business Central

This Dynamics NAV Coffee Break provides clear, step-by-step instructions for modifying and personalizing columns in Dynamics 365 Business Central. The video will walk you through how to select exactly what you do or don’t want to see as well as how to resize, reorder, add, or delete columns. Follow along to learn how to personalize your Business Central environment and revert back to defaults if desired.

Bron : ArcherPoint
Lees meer…

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…

Split multiple columns into rows in #PowerQuery

Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always turns out to be a difficult task than I first assumed. On top of that, with this particular data source; data was coming as semicolon delimited text. Basically, there were many columns like Mile Stones and Sub Milestones, their related data and so on.

Bron : Prathy’s Blog
Lees meer…

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…

Making Sure All Columns Appear When You Combine Data From Multiple Files In Power BI/Power Query M

Here’s a really common problem that occurs when combining data from multiple files, or indeed any type of data source, in Power BI/Power Query/Excel Get&Transform. Imagine you have a folder with two Excel files in, and each Excel file contains a table called SalesTable:

Bron : Chris Webb’s BI Blog
Lees meer…

Dynamics Column reports in NAV 2017

Many of client required report with dynamics Column in Navision. We all know dynamics data is displaying top to bottom. But what happen if customer want data left to right. And As data increase Column also increase in the report.

In this blog, I will show you Item inventory report, where Item will display in row and location will display in Column. But when you add any new location in Navision and Post any Item Journal, sales, purchase entry for that location, that new location will added in report Column.

Bron : Cloudfronts
Lees meer…