What does FirstSortedValue return if no value was found?
I know from help that it does return Null() if there are two or more values within the current selection and given expression. But what does FirstSortedValue return if no value was found? How do I know if e.g. there is a value of zero instead of no value?
I'm trying to get the value of the last Wednesday of the selected month. If there's no value it should give me the value of the last day of the previous month. But if the value of the last Wednesday of the selected month is zero then it should return zero.