Date range card format issue

[Anonymous]

Hi,

I have the following date table which is in format dd/mm/yyyy

After I make a measure to display the date range as a visual, the format changed to mm/dd/yyyy instead of my expected outcome dd/mm/yyyy.

Any idea what I missed?

Thank you.

[v-cazheng-msft · Accepted solution]

Hi @Anonymous,

You may try this Calculated column.

Date Range = FORMAT( MIN('Table'[Date]),"dd/mm/yyyy")&"-"&FORMAT(MAX('Table'[Date]),"dd/mm/yyyy")

The result looks like this.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

That works, thanks a lot!