Power BI: return a value based on condition

In this article, I will explain different scenarios about returning a value of a column based on criteria. I have this table and I want to return the early date for each incident (1 condition):


power bi

And also only for level 2 (2 conditions):

CALCULATE(MIN('table'[argument1]),FILTER('table','table'[argument2]="value" && EARLIER('table'[argument3])='table'[argument3]))

power bi


  • Replace “table”, “argument” and “value” by yours
  • For the last date, replace MIN by MAX
  • To add a third condition, just add a new argument inside the FILTER

I want to know the support who has the early date for each incident:


power bi
power bi

I have another table called “sheet” like that:

power bi

I want to add some columns from “table”, in excel, I have the VLOOKUP function and the equivalent in Power BI is LOOKUPVALUE:

LOOKUPVALUE('table value return'[argument value return],'table value return'[argument value match],'table value compare'[argument value match])

For instance:

power bi

I can add a second or more criteria by just adding another “argument value match”. For instance:


LOOKUPVALUE will not work with multiple values including empty cells, for instance, imagine that the “column 3” of “table” has empty values:

power bi

In such situation, I will use this formula:


NOTE: LOOKUPVALUE doesn’t need to have a relationship but MAXX needs it

power bi
power bi

Interesting Management