Software + Imagination
Most Unified Service Desk controls have a “default” action. This action performs an action called default. In cases where the control does not have a default action, running this action will load the control. For example, let’s say we have a custom hosted control called “Dashboard” of type CRM page. We can run the default action from the debugger: This will open the hosted control:
We can also perform time intelligent functions on our date fields in DAX. Let’s compare this year’s sales to last year’s sales. We will create a new measure for previous year sales. First, let’s create a date table. This is created in Power BI Query Language (M): Next, create the measure. We are calculating the sum of the extended price, in the previous year, using the PREVIOUSYEAR function: What this means, is … Continue reading Using DAX PREVIOUSYEAR
Some DAX functions will return a single date. Let’s go through some of these with our dataset. STARTOFMONTH If we apply this to our data without a filter, it will find the start of the first month: LASTDATE ENDOFQUARTER Applying this to 2016, it uses the first 2016 record (09/02/2016) and gets the end of that quarter:
Let’s start with a dataset that has sales orders. There are sales order lines: And the data looks like this: However, there is no extended price in this dataset. To calculate it, let’s add a new calculated column. Click on the ellipse on the dataset: And select New column: Add the formula: The new column will appear in the dataset: And the new column can be added to our Power BI … Continue reading DAX Calculated Columns
DAX, or Data Analysis Expressions, is a library of functions, formula and query language used in analytics. It is used in: Power BI SSAS Tabular models (SQL Server Analysis Services) Power Pivot in Excel To write DAX formulas in Power BI, open Power BI Desktop and go to your dataset. In the example below we have Transactions: Click on the Ellipse next to the dataset and you will see “New measure” … Continue reading Introduction to DAX (Data Analysis Expressions)
In Unified Service Desk, we can use the Navigate action to navigate in our controls. For example, let’s say we have a control that displays a CRM Page, called Dashboard: The control shows as empty as we have not specified the page to load. The Navigate action specifies the URL to navigate to: Or to a webpage:
The CRM Page hosted control is a type of hosted control in USD. The control contains several predefined UII actions. Here we will go through using the control and using some of these UII actions. Let’s take a look at the Account hosted control in our application. This control is invoked when an account is selected from the Search control.  USD knows the selection is an account and uses windows routing rules to determine … Continue reading CRM Page Call Actions from Debugger
To manage users and groups in Azure Active Directory, select Active Directory in portal.azure.com: To add a new group, select Users and Groups->All Groups->Add: Enter a group name and click Create: To add new users, select All Users->Add: Enter in details and click Create: You will then be able to manage the user:
In this example, we will create a Hello World application for Node.js. Let’s start with a simple example. I have installed Node.js on Windows and have a Node directory in C:\ drive. In command prompt, cd to this directory. In that directory is a JavaScript file that writes out a console log “Hello World”: To run the file, enter: node HelloWorld.js Hello World is returned by Node. Now create a new … Continue reading Node.js Hello World on Windows
Query Expression is a class used to build queries in Dynamics CRM. Let’s go through some examples of how to use this. Here are some of our records in CRM: If we want to return the Alexis Fry contact, we can use the RetrieveMultiple method to do this. It will retrieve all records where the contact name is Alexis Fry, in this case one record. Note if you know the GUID … Continue reading Dynamics CRM Retrieve Multiple and Query Expression