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
Solved! Go to Solution.
Hi
Use AND() function for multiple conditions
SELECT ( MyTable[DesiredColumn], AND ( [Column1]=โSomethingโ, [Column2]=โOtherโ ) )
Hi
Use AND() function for multiple conditions
SELECT ( MyTable[DesiredColumn], AND ( [Column1]=โSomethingโ, [Column2]=โOtherโ ) )
Great ! Thanks a lot, it works perfectly. Have a nice day
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |