FIRST DATE function

[Anonymous]

Hi everyone, 

My data has a column with "DepartureDates" and the first one is 14-08-2019 but, when using the funtion 

StartDate = FIRSTDATE(vw_Report_REPLICA_Invoices_Details[DepartureDate].[Date]) the result is 01-01-2019...

Do you have any ideia why is it happening or how can I have the first Departure Date?

Thanks in advance,

Sofia Vaz

[v-frfei-msft]

Hi @Anonymous ,

This option in power bi desktop  will help you to find the root cause of that. So when you turn on time intelligence option, power bi will try to analysis your data value column as a hidden calendar. These extend fields which you mentioned are from analysed hidden calendar, you can direct use these fields to get different date unit from date value without specific dax date functions.

So here just removed the .[Date] and go ahead.

[Anonymous]

@Anonymous Please remove .date from formula and try 
StartDate = FIRSTDATE(vw_Report_REPLICA_Invoices_Details[DepartureDate]) 

[amitchandak]

Remove  .[Date]  and try. If still does not work. If possible please share a sample pbix file after removing sensitive information.
Thanks

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601