Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have one calculated column as 'Program Status'. my expression for that column is, if i have value in my completion_date column, then it should display "Certified" .. else it should display "Notcertified" .
The Problem is "I have blank values as well as spaces in the completion_date .. for spaces also it is taking Certified.
Below is my expression:
Here, it shows completed for the one it has date and it shows completed if dont have date also.
Thanks,
Sai
Solved! Go to Solution.
Hi @Anonymous
Try replacing the AND with OR.
Hope this helps
Thanks,
George
Hi @Anonymous
You can convert the data type to date, this should get rid of all the spaces and convert this to blanks, or you can use the TRIM function on your date field.
Using OR instead of AND should work as well.
Hi @Anonymous
You can convert the data type to date, this should get rid of all the spaces and convert this to blanks, or you can use the TRIM function on your date field.
Using OR instead of AND should work as well.
Hi @Anonymous
Try replacing the AND with OR.
Hope this helps
Thanks,
George
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |