Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a calculated column where it works out the last date of a note added. Some rows dont have notes added so shouldnt have a date in this column, therefore leaving it as a "-". The problem I have is that it wont let me convert this column to dates since there are dashes in the column as well. I need this converted to date to be able to sort the column in a table, however I cant enter 0 or another number as this would add a date in to the ones which shouldnt have a date on.
Any ideas?
thanks
Solved! Go to Solution.
Use BLANK() for rows with no data. So, return a date or a BLANK()
Use BLANK() for rows with no data. So, return a date or a BLANK()
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |