Using QUOTIENT and MOD in Power BI
From Warehouse to Dashboard Ever tried to calculate how many full pallets you can fill with boxes, and how many are left over? The key solution to this is by using QUOTIENT() and MOD() in Power BI to break down totals into usable units. By calculating this it can help multiple areas, such as inventory planning, logistics, and operational efficiency. Case Scenario: For instance, you have a business which is operates in the logistics industry: You want to calculate: Example: 1,250 boxes, 48 boxes per pallet Shipment ID Product Total Boxes Boxes per Pallet S001 Widget A 1250 48 Step by Step walkthrough of quotient and MOD in Power BI If you want to follow along with this example, start with this dataset Shipment ID Product Total Boxes Boxes per Pallet S001 Widget […]
Best Practices for Using Explicit Measures in Power BI
Part 2: Best Practices for Using Explicit Measures in Power BI (Part 2 of a 2 part post about modelling in Power BI) In our previous post we explained the differences between implicit and explicit measuresUnderstanding Implicit and Explicit Measures in Power BI This post builds on that and explains some best practices for using […]
Implicit and Explicit Measures in Power BI
(Part 1 of a 2 part post about modelling in Power BI) In this post we will explain the key differences between implicit and explicit measures in Power BI We will also explain the “Discourage Implicit Measures” feature and its significance Understanding Implicit and Explicit Measures Implicit Measures What are Implicit measures in Power BI? […]
How to Sync Slicers in Power BI: Step-by-Step Guide
This post explains how to sync slicers in Power BI, without any complex code Slicers are an excellent way to give your users the ability to explore data, allowing users to use the slicers to filter the data down to particular information of interest. But, if your data has different data sets with common values […]
Split a column in BigQuery
This quick guide shows you how to split a column in BigQuery When working with text data, quite often you need to split a column or trim excess characters to clean the data This quick guide shows you how to do it. Using URL data from Google Analytics GA4 to create separate columns for the […]
Import XML into Excel
Importing XML data into Excel allows you to have a readily available data source that can be refreshed on Demand Once that data loaded into Excel you can use Excels features to explore, filter, sort or augment that data from other sources What is an XML file? An XML file is a plain text file […]
Azure Data Factory Best Practices and Tips
Best Practive Data integration to drive operations and make informed decisions. Microsoft Azure Data Factory (ADF) is a cloud-based data integration service. It is available as part of Azure and also as part of the Microsoft Fabric Offering. It offers a robust and scalable solution for managing, orchestrating, and automating data pipelines. This blog highlgihts […]
SQL Server Date Handling
Working with dates in sql is one of the most challenging parts of data manipulation. In this blog we aim to describe some of the complexities of date handling in SQL Server. Data Types Prior to Microsoft SQL Server 2008 the only data types available were datetime or the smalldatetime. With the launch of SQL […]
Navigating Power BI Data Alerts
Introduction Whilst reporting is a key component of any business, how do you respond to key changes. How do you ensure actions are generated when the data changes beyond the limits you set. As part of our Business Support Expert Services this can be a really efficient way to set up reports to monitor values […]
How to Create Drop Down Lists in Excel
The Drop down list in Excel is a useful feature that allow users to select an item from a list of options. They are commonly used in data entry to control what data is entered. And to ensure that users do not enter incorrect data, preventing some errors This post shows you how to create […]
