Transform – Pardaan.com

“In the Previous” Date Filters In Power BI/Get&Transform/Power Query

The Query Editor in Power BI/Excel Get&Transform/Power Query has a number of built-in ways to filter data in date columns relative to the current date, such as the “In the Previous” option. However these filters behave in a way I find non-intuitive (and I’m not alone)…

9 January 2018

Data & Analysis

Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform

When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need: Bron : Chris Webb's BI Blog Lees meer...

20 June 2017

Data & Analysis

Power Query/Get & Transform: The Future Of Data Loading In Excel

Last week, Dominic Petri shared a link on Twitter that contained some important news from Microsoft: as of the March release of the Office 365 click-to-run version of Excel 2016, the old methods of loading data into Excel will be replaced by the newer “Get &…

13 March 2017

Dynamics NAV & BC Tips & tricks

When transforming Form to Page

In this article I want to share with my peers how to hold the same two columns in a page as we have in a form (see illustration beneath). Bron : 1 Click Factory Lees meer...

10 February 2012