Forum Discussion
Select the first value by date
Hello! How can I via a measure get the oldest value by date in a table like this? Tried FIRSTDATE, LASTEDATE and EARLIEST but it returns first 2021-01-01. Kind Regards, Anthon ...
Hi Anonymous
The type of your column is Date/time, however, the type of argument that FIRSTDATE() accepts is Date.
FYI:
Besides, you can use the function MIN() mentioned by Jihwan_Kim.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.