barcelona

more panorama pictures

excel

1 click excel macro tool

Power BI: get a value if 2 conditions are met

When I need that 2 criteria or more are met in order to get a value, I use “&&”, saying this way, it looks very abstract. Imagine that I want to show yes or no if 1 condition is met, this is the formula:

IF('table'[argument]="xxx","yes","no")

Now for 2 conditions:

IF('table'[argument]="xxx" && 'table'[argument]="yyy","yes","no")

Let’s do some example, with 1 condition:

power bi

Here I am asking to say “yes” if the priority is P4.

With 2 conditions:

power bi

Here I am asking to say “yes” if the priority is P3 and if the ticket has been created before 28/06.

If I want 3 criteria, I will just add another “&&”. The principle is the same if I want to use other functions, for instance:

COUNTROWS(FILTER(ALLSELECTED('table'),'table'[argument]="xxx" && 'table'[argument]="xxx"))

power bi

Interesting Management