SELECT() with multiple conditions

[Jean-Baptiste1]

Hi,

I am looking for an expression to get a list selection with multiple conditions.
I tried to write a SELECT() function wich take into account two conditions, but it does not work, like SELECT(myTable, condition1 and condition2, FALSE)

How can i get this kind of table ?

Thanks

[Mikko_Palmu · Accepted solution]

Hi

Use AND() function for multiple conditions

SELECT ( MyTable[DesiredColumn], AND ( [Column1]=“Something”, [Column2]=“Other” ) )

[Jean-Baptiste1]

Great ! Thanks a lot, it works perfectly. Have a nice day