Tech blog with tips, tricks and hacks
for EVs, hardware, software, home automation, programming and more
Data Analysis Expressions (DAX) is a powerful language designed to handle data manipulation and queries in Microsoft’s various data platforms, notably Power BI, SQL Server Analysis Services (SSAS), and Power Pivot in Excel. I’ll dive into DAX a bit in this article, covering its history, applications, and the broad spectrum of functions it offers, particularly
Power BI is a powerful business analytics tool developed by Microsoft that enables users to visualize data and share insights across the organization, or even embed them in an app or website. It can connect to a broad range of data sources, from Excel spreadsheets to cloud-based and on-premise SQL Server databases, and more. Power
Power BI is a powerful tool for data visualisation and analysis, but it can be overwhelming for new users. Here are some hints and tips to help you get started: 1) Start with a clear goal in mind Before you begin creating your report or dashboard, take a moment to think about what you want
If you’re working with data in Power BI and would like to count how many duplicates there are, the below example will help you. Let’s start with the table structure. For this example, lets says we want to see how many people have the same first name, and the data looks like this: EmployeeID FirstName
If you have a column containing numeric values in your Power BI report, depending on the graph, it can sometimes be too much and produce some messy graphs, like the below: To make this look better, you might want to group the data into ranges instead, to make it easier to read. For example, if