-
A Best Practice Use of Formatting, Variables and Comments in Power BI DAX Expressions
Colin Maitland, 16 September 2019
In this article I demonstrate a best practice for the writing of a Data Analysis Expression (DAX) in Power BI regarding the use of formatting, variables and comments.The formula used for my demonstration adds a calculated field named Is Supporter to a table named Supporter. This is a table of merged
Read the full article here -
How to update Dynamics 365 Option Set controls in a CDS Canvas PowerApp
Colin Maitland, 10 September 2019
In my previous articles, I have demonstrated how to set the default values for Lookup and Option Set field bound combo box controls in a Canvas Power App connected to a Leave Requests entity via the Common Data Service. In this article I demonstrate how an Option Set field bound combo box control ca
Read the full article here -
How to use Parameters in Power Query in Power BI
Colin Maitland, 09 September 2019
In my previous article I demonstrated how to use Connection Parameters in Power BI for the configuration of the Source step in Power Queries used to load data from Dynamics 365 (Online). In this article I will demonstrate how to use Parameters in Power Query.The following image shows the first three
Read the full article here -
How to Configure Data Source Setting Parameters for a Power BI Data Model
Colin Maitland, 06 September 2019
In this article, I demonstrate the use of parameters for connecting a Power BI Data Model to Dynamics 365 (Online). This approach simplifies the subsequent task of updating the Data Source Settings after the Data Model has been published to the Power BI Service. For instance, it may be desired to co
Read the full article here -
How to Change a Power BI Relationship from Many-to-Many to One-to-Many
Colin Maitland, 05 September 2019
Recently when configuring a Power BI Data Model for Dynamics 365 I encountered a situation where I was not permitted to create a One-to-Many relationship in the data model between a Dimension table and a Fact table. Power BI automatically created a Many-to-Many relationship between the tables concer
Read the full article here -
How to Update Related Date Picker Controls in a Canvas PowerApp
Colin Maitland, 04 September 2019
In this article, I demonstrate how to configure two related date picker controls in a Canvas PowerApp so that Date To is updated to Date From, and Date From is updated to Date To, if the User selects a Date From date that is greater than Date To or a Date To date that is less than Date From.The exis
Read the full article here -
How to Programmatically set Date Picker and Days Controls in a Canvas PowerApp
Colin Maitland, 03 September 2019
In this article, I demonstrate how to configure the default values for a Days From and Days To date picker controls and a related Days control in a Canvas PowerApp. I also demonstrate how to programmatically update the Days control to display the number of days between the two selected dates when th
Read the full article here -
Optimise Setting Default Values for Dynamics 365 Lookup Controls in a Canvas PowerApp
Colin Maitland, 23 August 2019
In a previous article, I demonstrated how to set the default values for Dynamics 365 Lookup fields in a Canvas PowerApp. The example used was a Leave Requests app that requires the selection of Requester and Manager.The following image shows the formula used for setting the default Requester to the
Read the full article here -
How to Set the Default Value for a Dynamics 365 OptionSet Control in a Canvas PowerApp
Colin Maitland, 22 August 2019
In this article, I demonstrate how easy it is to set the default value for a ComboBox control associated with a Dynamics 365 Option Set field in a Canvas PowerApp. The approach demonstrated eliminates the need to change the bound ComboBox control to an unbound DropDown control. Because of this, it a
Read the full article here -
How to set the Default Value for a Dynamics 365 Lookup Control in a Canvas PowerApp
Colin Maitland, 20 August 2019
In this article, I demonstrate how easy it is to set the default value for a ComboBox control associated with a Dynamics 365 Lookup field in a Canvas PowerApp.The demonstration application is a sample ‘Leave Requests’ Canvas PowerApp. The app uses the Common Data Service (CDS) connector to access a
Read the full article here -
How to Import a PowerApp Package
Colin Maitland, 28 May 2019
PowerApps can be exported as a package from one environment and then imported into another environment. In this article, I will demonstrate how to import a PowerApp package. This demonstration uses a simple ‘Leave Requests’ PowerApp that connects to Microsoft Dynamics 365. A Plan 1 or Plan 2 licence
Read the full article here -
Context Transition when Using CALCULATE Function in Power BI
Colin Maitland, 23 May 2019
When writing and testing DAX formulas, it is important to understand the Evaluation Context in effect for each part of the formula; i.e. Row Context and Filter Context. The purpose of the DAX CALCULATE function is to modify the Evaluation Context of an expression. In this article, I will demonstrate
Read the full article here -
How to Sort Multiple Sets of Age Groups in Power BI
Colin Maitland, 22 May 2019
In this article, I will describe how to configure sorting for an Age Group dimension in Power BI that has multiple sets of Age Groups for the same age ranges. The example discussed in this article is based on aggregating Referrals stored in Dynamics 365 by Age Group. The Power BI Data Model has an
Read the full article here -
Dynamics 365 Currency Configuration for Price List Items
Colin Maitland, 20 May 2019
In Dynamics 365 several Pricing Methods may be used for the configuration of Price List Items. These are Currency Amount, Percent of List, Percent Markup and Percent Margin. The Percent Markup and Percent Margin Pricing Methods may be proportional to either the Current Cost or the Standard Cost of t
Read the full article here -
Flattening Opportunity and Opportunity Products in Power BI
Colin Maitland, 08 May 2019
In Microsoft Dynamics 365 the Opportunity and Opportunity Products entities form a Header/Detail relationship. This is a common type of relationship between entities. Other examples include Quote, Order, Invoice and their corresponding Quote Product, Order Product and Invoice Product entities. In Po
Read the full article here
Category List
Filter by Author
Adam Murchison
Alfwyn Jordan
Arthur Mandisodza
Calum Jacobs
Colin Maitland
David Mochrie
Dominic Liu
Gayan Perera
Harshani Perera
Isaac Stephens
Jaime Smith
Jared Johnson
John Barrencechea
John Eccles
Lauren Withers
Paul Nieuwelaar
Roshan Mehta
Roz Millar
Ryan Blaikie
Ryan Ingram
Sarah Coleman
Sean Roque
Shalane Williams
