Trying to return the maximum value of a filtered date column in Power BI

filter powerbi dax slicers
Alex Kitson picture Alex Kitson · Feb 5, 2019 · Viewed 9.5k times · Source

I have a table within Power BI that has a date field, and a value field. I am filtering on this date field, using a slicer, to sum all of the value data before the specified date. I would like to get this date value to use in a LOOKUPVALUE() elsewhere (to get a conversion rate).

Is there a way to accomplish this?

I have tried the DAX functions that return the values of a particular table/column with filters preserved but this never seems to work, and just returns the entire dataset, e.g. VALUES(), FILTERS(), ALLEXCEPT().

Any help would be greatly appreciated!

Answer

Alex Kitson picture Alex Kitson · Feb 8, 2019

I found a solution using measures.

The DAX for future reference: 

Filter Date = CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table'))

Related questions

Passing parameters to Power BI filter programmatically

In my application I'm displaying a Power BI report. It already works, so there's no problems with showing any report by its ID (guid). But there are some reports that need to be parametrized, for instance, with current year or …

Read More
Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
List comprehension vs. lambda + filter

I happened to find myself having a basic filtering need: I have a list and I have to filter it by an attribute of the items. My code looked like this: my_list = [x for x in my_list if …

Read More