Forum Discussion
FIRSTDATE doesn't work as expected
I created a simple measure = FIRSTDATE(Table[column].[Date]). In this column the first date is 2023-12-04, but when I put in the visual Card, it shows 2023-01-01. I having seen some people with problems using this function and others by helping improving formulas, however no one answer why doesn't work as expected?
PS.: I am not english native speaker, any doubt just ask.
hi, HugoDataAve2023
problem occure due to (.[Date]) part
try onlymeasure = FIRSTDATE(Table[column])
check below image and check my first date in left table
without (.[Date])
with (.[Date])
2 Replies
- Dangar332Resident Rockstar
hi, HugoDataAve2023
problem occure due to (.[Date]) part
try onlymeasure = FIRSTDATE(Table[column])
check below image and check my first date in left table
without (.[Date])
with (.[Date])
- HugoDataAve2023Frequent Visitor
It work. Thanks.