Introduction Understanding the difference between your standard aggregate functions and your X aggregate functions is useful because there will be scenarios for using one over the other. How does SUM() work Sum, average, min, max etc are all fairly easy to understand. They accept a single column input and aggregate the data. Here is the … Continue reading DAX: The difference between SUM and SUMX

In Power BI you can add conditional formatting to your tables by using hex colour code values from another column.I prefer this method of managing your conditional formatting for two reasons. Its quicker to set up rather than using the colour scale form, and the column can be re-used.In this example I've created a measure … Continue reading Conditional Formatting Based on Field Value in Power BI

The correct way to calculate age in DAX is by using the YEARFRAC() function instead of DATEDIFF() because we can get a more accurate age by using fractions. Create a calculated column named Age You also might want to wrap this calc around an IF statement to account for when some birth dates are blank. … Continue reading Calculate Age in DAX from Birthday