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 […]

Power BI Licensing: The Ultimate Guide

Leverage tools like Power BI is crucial for businesses seeking to gain insights and make informed decisions. However, navigating the various licensing options can be a challenge. This guide aims to demystify Power BI licensing, helping you choose the right plan for your organization. Understanding Power BI License Options When it comes to Power BI, […]

Joblogic Integrations Dashboard with Power BI

 Introduction This post outlines our recent approach to a Joblogic Integrations Dashboard with Power BI for a client. Our client offers engineering maintenance services across the UK. They utilize Joblogic field service management software, an all-encompassing field service management software, for activity monitoring. Field Management Software Field service management software improves efficiency, productivity, and customer […]

Conditional Format a line chart in Power BI

How to Conditional format a line chart in Power BI (This is a workaround to show you how you can conditional format a line chart in Power BI) Power BI does not at first seem to have an option to add conditional formatting to a line chart, but, there is a way to make it […]