Tag: VALUES DAX function

VALUES Function (DAX) In Power BI

VALUES-Function-DAX-In-Power-BI

In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create useful automation when working on a model with multiple date measures. You can 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 the

Continue reading

Using DAX Table Functions In Power BI

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

Continue reading

DAX Table Functions In Power BI

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

Continue reading

A Deeper Understanding Of Advanced RANKX

Advanced RANKX - How To Understand This Function More Deeply

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

Continue reading

How To Compare Two Lists Of Calculated Data Virtually – An Advanced DAX Technique

How To Compare Two Lists Of Calculated Data Virtually - Advanced DAX Technique

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.

Continue reading