Forum Discussion
Expressions that yield variant data-type cannot be used to define calculated columns.
I'm not really sure, why this is throwing this? I'm grabbing the earliest time? ERFTime =
IF (
COUNTROWS (
FILTER (
RELATEDTABLE ( 'Apparatus Responses' ),
'...
HotChilli
Community Champion
Community ChampionAn IF statement has to return the same datatype from any path it follows.
That code can return different data types.
Well the datediff is returning an integer?
- v-diye-msft
Community Support
Hi Robert4049 ,
Yes, Datediff returns the count of interval boundaries crossed between two dates.
Best regards,
Dina Ye
