In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create a useful automation when working on a model with multiple date measures. You may watch the full video of this tutorial at the bottom of this blog. The VALUES function (DAX) returns a one-column table that contains the distinct values from
Tag: VALUES DAX function
I want to introduce you to a group of functions in Power BI called table functions. These functions include FILTER and ALL which we already used or mentioned in other topics. There is a whole range of other table functions which includes functions like VALUES, TOPN, and ADDCOLUMNS. However, we are not going to cover
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. You may watch the full video of this tutorial at the bottom of this blog. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use
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. You may watch the full video of this tutorial at the bottom of this blog. The INTERSECT function is the best thing to use in cases like these.