Format – Pardaan.com

Nine is a magic number in AL and Business Central

Some times the smallest parameter can have a great effect, check this video where I discover the might of the number nine 🙂 Source : Hougaard.com Read more...

14 July 2023

Dynamics NAV & BC Tips & tricks

Text splitting and formatting using Lists

I get a lot of questions from all my great viewers, and many of these questions turn into videos. This is one of them. In this video, I take a look at how we can use the List datatype to help us split strings in a…

27 January 2023

Dynamics NAV & BC Tips & tricks

Everything can be a string, as long as you know FORMAT in Business Central

Type conversion to strings (Text) is easy, as long as you master the FORMAT command, check it out: Source : Hougaard.com Read more...

30 August 2022

Data & Analysis

Dynamic Formatting of Switch Measures

Using a switch measure to toggle results is a mature and common technique used in Power BI and Power Pivot for Excel. For example, a switch measure can be used to toggle what appears on a chart so that the end user can easily switch the…

10 September 2020

Dynamics NAV & BC Tips & tricks

Tip: Format AL Files OnSave in Visual Studio Code

Maybe everyone else is already doing this and I’m just slow on the uptake but Visual Studio Code has options to automatically format files at various points. The AL extension for VS Code provides a formatter for .al files. You can run it manually with the…

13 March 2020

Data & Analysis

Power BI Custom Format String Examples, Part 2: Dates And Times

In my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two reasons: there are a lot more useful examples…

27 September 2019

Data & Analysis

Power BI Custom Format String Examples, Part 1: Numbers

Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very flexible new feature because the existing documentation for VBA isn’t…

16 September 2019