FIRSTDATE nor working

[Abevann]

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

[AlexisOlson · Accepted solution]

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

[Abevann]

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

[Abevann]

Hi Alexis,

You are absolute right, thanks a lot