Calculated column accessing blank fields in rows

(0) Share

Report

Posted on by shayne_marques

I have an issue where I am trying to add a calculated column into my table in PowerApps Portals. The problem I run into is that I am trying to do a complex comparison with a field which is blank in some rows in my table. Is there any way to account for these types of rows? Is there any way to set a default value for all the rows in a column?

For some context, the calculated column tries to do comparison operations with fields of type Date/Time. Ideally, I am looking for a way to set a default value for the entire Date/Time column like 00-00-0000 (which would make comparisons later on a lot easier and less ambiguous)