Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
How you create this first and last measure
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |