In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical
This tutorial will go through an advanced example on the DAX function RANKX in Power BI. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use it for a range of different contexts in your report page. However, it can also
When working with calculated data, comparing different data sets will sometimes be necessary. I’m going to show you how to do that by combining different table functions. The INTERSECT function is the best thing to use in cases like these. Some may also say that EXCEPT is just as useful in comparing calculated data. But
In this tutorial, you’ll learn how to work out the current staff population for multiple dates in Power BI using the COUNTROWS and FILTER function. This discussion is based on a question in the Enterprise DNA support forum. A Power BI user wanted to calculate the number of staff members that have been hired within
Over the years, visual headers have significantly improved. You can now use these headers to enhance the appearance of your reports. These headers also come with headings or titles. In this tutorial, I’ll be showing how you can create a Power BI dynamic title or heading in your reports. A dynamic title or heading can
