It seems that the MIN (and MAX) function is capable of finding the first value in a text column, but the intellisense suggestes otherwise. See my tweet/gif file here for more details https://twitter.com/ExceleratorBI/status/1109896261103083520
@MattAllington ,I have reported this issue internally:CRI 112300570. And I will post back once I get any updates.Regards,Lydia
The fix will be released in June release of Desktop.
Best Regards,Qiuyun Yu