Direction of travel on a map in Power BI
Can we show the Direction of travel on a map in Power BI? Can it be done with the standard Power BI mapping visuals? A global commodity trading client of ours had a requirement to create a dashboard that presented the latest locations and headings for a range of container ships This was part of […]
UNION in DAX
Using UNION in DAX is a third option to combine data for analysis in Power BI We recently showed how to do this in SQL UNION in SQL and how to do similar in Power Query APPEND in Power Query It isn’t always possible to do this in SQL such as if the datasets are […]
How to Append Data in Power Query: A Step-by-Step Guide
Last week we looked at how to combine datasets in SQL using UNION UNION in SQL – Select Distinct This week, we are looking at using the same source data, but doing the combining in Power Query, via the transform options in Power BI It is not always possible to combine the data in SQL, […]
UNION in SQL
A Guide to Using UNION in SQL: Combining and Manipulating Data Introduction: Understanding the Purpose and Functionality of UNION in SQL The SQL UNION operator allows us to merge the results of two or more SELECT statements into a single result set. It performs a set operation by combining rows from different tables based on […]
Joins in SQL
Joins in SQL: A simplified guide Introduction to joins in SQL This guide is aimed at explaining in simple terms the different types of joins between tables in SQL We use simplified real life examples combining data from Products, Stores, Sales and Inventory What we will not do unlike other guides we have seen is […]
Connect Power BI to Google Big Query
A Quick Guide to Connecting Power BI to BigQuery Power BI is a leading business intelligence platform, with powerful features for self service analysis BigQuery is a fully managed cloud based data warehouse platform for you to manage your data The great thing about both of these platforms is that they both have a really […]
Automatically reformat SQL
Automatically format SQL with this great free tool At Select Distinct we love to share tips and timesavers to help you become more efficient, and when we find great tools we love to share this knowledge (We have no affiliation to this product or site and get no commercial benefit from it) We found this […]
Group by ROLLUP function in SQL Server
Introduction to ROLLUP in SQL Server Did you know that there is a simple way to add roll up sub totals in SQL Server? SQL ROLLUP is an extension of the GROUP BY clause in SQL, providing a way to generate subtotals and grand totals for multiple dimensions within a dataset. It enables analysts to […]
Advanced Top N Filter Power BI
The basic Top N filter in Power BI can be very useful. But if you need to show the values of the whole you will need to use an advanced Top N Filter Measure This guide shows you how you can set it up If you use the standard top N filter you would see […]
How to use Custom Formats in Power BI
Custom Formats in Power BI allow you to create your own specific formats so that you are not limited to the pre-defined options that come as defaults Some organisations have specific standards for things such as date formats, these can be catered for using custom formats For example if you want your date formats to […]
