Select Distinct Logo Clear Background

Unlocking the Power of DAX LOOKUPVALUE in Power BI


DAX LOOKUPVALUE function is the subject of this blog. It is particularly useful for retrieving values from tables based on specific conditions. In this blog, we will explore the LOOKUPVALUE function, its syntax and use cases. We will also cover examples to help you leverage its full potential. This is similar to the Power BI […]

What is Business Analytics

What is business analytics

What is Business Analytics? Introduction: What is Business Analytics and why use it? Business analytics refers to the skills, technologies, and practices used to examine the data and performance of an organisation. It aims to generate insights that can help improve business performance and decision-making. Business analytics can help businesses understand their current situation. Predict […]

Divide by Zero Errors

Divide by Zero header image

A common error that analysts experience is the divide by zero error This article explains across a range of platforms how to avoid these issues with simple logic to make sure the division by zero errors do not get in the way of analysis Why can we not divide by zero? Dividing by 0 makes […]

Steamlining Success with Payroll Automation

Payroll automation

Are you looking for a payroll automation solution? Are you tired of your business spending hours manually calculating your payroll? Do errors occur every month as you process your overtime? Do you wish there was a better way to streamline your payroll process? Many businesses face challenges of managing complex payroll processes in a fast […]


Combine data with 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 […]