Forum Discussion

HugoDataAve2023's avatar
HugoDataAve2023
Frequent Visitor
2 years ago
Solved

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 probl...
  • Dangar332's avatar
    2 years ago

    hi, HugoDataAve2023 

    problem occure due to  (.[Date]) part
    try only 

    measure = FIRSTDATE(Table[column])

     

    check below image and check my first date in left table

     

    without (.[Date])

     

    with (.[Date])