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 outc...
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
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
That works, thanks a lot!