Date Format in Card

[ausrine]

Hi all, 

I have a dataset with dates in format dd/mm/yyyy. I use measures FIRSTNOTBLANK() and LASTNOTBLANK() to get date boundaries and these are in format dd/mm/yyyy as well. But once I join these dates in a card with measure

= "CALLS BETWEEN " & [FIRST DATE] & "-" & [LAST REFRESH]

I get date format mm/dd/yyyy (see attached).

Any ideas why it changes automatically? Location is set to the UK.

Thanks!

Ausrine

[Shahid125238]

How you create this first and last measure

[v-yulgu-msft · Accepted solution]

Hi @ausrine,

In my test, the date format is "dd/mm/yyyy" in all these three measures, please see below image:

Also, I noticed that there is no such a date format "dd/mm/yyyy" option under the format drop down list. We should use Format function to get desired format. [Date] is in default format after loading dataset to Power BI desktop, [Date2] is the returned format.

Best regards,
Yuliana Gu

[ausrine]

Thanks @v-yulgu-msft!