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 hereIn 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 hereClickDimensions Email Marketing contains some great features which allow marketers to create effective emails and complex campaigns. At the time of writing this blog, the components outlined below are not yet available in Dynamics 365 for Marketing.Split (A/B) testingThis feature enables marketers t
Read the full article hereStoring data in a CDS entity is a useful way to have it accessible to your PowerApps applications. This is because rather than embedding the data source directly into each of your applications you can connect multiple apps to one source. Another benefit of using CDS is that you can create a Data Int
Read the full article hereIn 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 hereIn Dynamics 365 v9 you are able to merge two records together using the Out-Of-The-Box (OOTB) Merge Button. The Merge Button appears when you select up to two records in a View and allows the data of two records to be merged into one. The Merge button will appear in the ribbon. When selecting the M
Read the full article hereWhy use Document Templates in Dynamics 365? Having document templates set up can improve document quality across the whole business. It can save time by having a document populated with Dynamics 365 data with just a few clicks as well as ensure a consistent look and feel out to your customers.I have
Read the full article hereIt is easy to search for an item in PowerApps with the built in Search() function by simply setting the Items attribute in your Gallery to Search(source, textbox.txt) as shown in the image below. However, this only looks for that exact sequence of characters/words. Sometimes you will want to search
Read the full article hereRecently one of our Dynamics 365 clients came to us saying that some users were unable to see the results of a duplicate detection rule when entering new contacts. Instead of seeing the duplicates that had been found by the rule, an empty view like the one below was displaying: After a bit of
Read the full article hereWith the April 2019 Release of Dynamics 365 version 9, a few things have changed. One being the options within the settings cog located at the top right-hand corner of the screen.You now have a few different options: 1. Personalization Settings 2. Advanced Setting
Read the full article hereNow that I've got your attention, the truth: Dynamics 365 CRM v9 is actually very quick! The Power Platform team has done an amazing job getting screens to load within a couple of seconds. This of course is the case for the majority of people using the platform. However, sometimes, you’ll hear comme
Read the full article hereHere’s a quick and easy tip for you. Suppose you have multiple people in your organisation with the System Administrator or System Customizer Security Roles. This gives them the right to create solutions. Sometimes, a change is made in your system and even though you can track it down to a solution
Read the full article hereIn 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 hereYou’ve commissioned a shiny new CRM 6 months ago. You’ve gone through the analysis and design phase; development is done and the final system testing by your CRM partner is in progress. Excitement is mounting, you can’t wait to get your hands on it! BUT, have you thought about what your plan is to t
Read the full article hereWhy use a Lookup over an OptionSet? OptionSets are a simple way to deal with lists and will meet most of your requirements, however in some situation you might want to use lookups. Why would I choose to use Lookups instead of OptionSets? • Large amount of Options:  
Read the full article here