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
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