Forum Discussion

ausrine's avatar
ausrine
Frequent Visitor
8 years ago
Solved

Date Format in Card

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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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