Forum Discussion

Abevann's avatar
Abevann
Icon for Helper III rankHelper III
5 years ago
Solved

FIRSTDATE nor working

Guys,

 

I am working with a date table, and looking for the first and last date of a table.

 

As you can see in the attached image, I have an interval form 01/01/2021 to 05/01/2021; the issue is that with the FIRSTDATE command I was expecting to have one value, the first date on the interval. The result is the exact same table from the slicer in the top right. I tried with LASTDATE as well with the same results. Is this a bug? According to the DAX command description, I should have a table with a single column and a single row.

 

Thanks, regards,

Abelardo

  • It looks like you defined this as a calculated column rather than a measure. Can you confirm?

3 Replies

  • It looks like you defined this as a calculated column rather than a measure. Can you confirm?

    • Abevann's avatar
      Abevann
      Icon for Helper III rankHelper III

      Hi Alexis,

       

      You are absolute right, thanks a lot

    • Abevann's avatar
      Abevann
      Icon for Helper III rankHelper III

      Hi Alexis, that's correct, thanks a lot, regards