Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
For Example -
Sample Table
Name Address count
John 20
Kenny 10
Now, I want to check if any one called peter exists in the above table.
I Want Q&A To show something like blank
Thanks, @GilbertQ for the quick response.
Exactly, I want a response indicating that Peter is not existing in the data set by throwing back blank.
Is there any function that I could use for achieving such functionality
Hi @pprbi
I would not think so, unless you did have Peter as part of the dataset, as without there being any values there is no ways of knowing if Peter did or did not exist.