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 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 only 

    measure = FIRSTDATE(Table[column])

     

    check below image and check my first date in left table

     

    without (.[Date])

     

    with (.[Date])

     

2 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar

    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])