Software + Imagination
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
OAuth is an open standard for authorization of websites and applications. It provides these applications with a simple, secure way allow their users to access their data. For example, let’s say you are a developer building an application. OAuth allows you to delegate the authorization. There are many websites and mobile applications that use Facebook or Google to authentication users. This is done through OAuth. OAuth has many benefits. The framework does … Continue reading Introduction to OAuth
DAX has various date functions we can use to help us visualize data. Let’s go through an example. In our dataset, we have order lines and we have the orders associated with them. Orders have a date field, i.e. when our customer placed the order: We have an active relationship in Power BI matching our orders and lines: We can derive the year, month, day, hour, minute and second from … Continue reading Using DAX YEAR