Column – Pardaan.com

Dynamics 365 Business Central: Cross-column search (OR filters on multiple fields) ★FilterGroup(-1)

Yesterday we discussed how to count the same value of different fields in one line (For example, how many “OK” in a line) in Business Central, I received a lot of feedback, which was much appreciated. Source : Dynamics 365 Lab Read more...

6 September 2022

Data & Analysis

Create a relationship with multiple columns in Power BI

When building Power BI reports we often need to join two (or more) tables together, but what if the relationship is defined by two or more columns? Relationships in Power BI are limited to single columns, but whilst this seems like a major limitation there is…

19 August 2020

Data & Analysis

Adding Tooltips To Column Headers In The Power Query Editor In Power BI And Excel

Here’s something that will excite all you M nerds out there! Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query Editor in either Power BI Desktop or Excel? Source : Chris Webb's BI Blog…

31 July 2020

Data & Analysis

Adding More Aggregate Columns To The Output Of Table.Profile

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data: https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/ Since that post was written a new, optional second parameter has been added to the function called additionalAggregates…

8 August 2019

Data & Analysis

Query by Example to Extract YYYY-MM from a Date Column

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including:…

7 March 2019

Data & Analysis

The Is Nullable Column Property In Power BI

The new Relationships view (or Modeling view – it seems to have two names) in Power BI Desktop that has been in preview since November 2018 not only makes it easier to work with complex models and set properties more easily, it also exposes a brand…

30 January 2019

Data & Analysis

Power BI And Column Order In M Queries And Dataset Tables

The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the columns in a table in alphabetical order. However there are a…

28 December 2018