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
Category: Power BI
Conditional Formatting Based on Field Value in Power BI
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
Calculate Age in DAX from Birthday
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
Create a Quick Date Table in Power BI
In this post I'll show you how to quickly create a date table in Power BI. To do this you'll need the below DAX and your Power BI report. In your Power BI report go to Modelling in the ribbon and select New Table. In the DAX editor paste the below date code and hit enter. … Continue reading Create a Quick Date Table in Power BI