Forum Discussion
Date range card format issue
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.
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
2 Replies
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