topic Re: Date range card format issue in DAX Commands and Tips

Date range card format issue

Anonymous — Wed, 28 Sep 2022 03:39:14 GMT

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.

Re: Date range card format issue

v-cazheng-msft — Thu, 29 Sep 2022 06:11:46 GMT

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

Re: Date range card format issue

Anonymous — Thu, 29 Sep 2022 06:44:18 GMT

That works, thanks a lot!