Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incorrect Date format in Text box

Hi All, I am creating a measure which returns date in textbox as below  but it returns date as 01-16-2021     how can I get date as 01/16/2021 amitchandak  Thanks
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi PhilipTreacy 

 

below is the screenshot of your pbix which you shared,here also i can see the same issue.

Or is Power BI using system date formate?

 

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

HI, Anonymous 

 

I can't see any issue on my side.Please check my sample file for more details.

_Title test = FORMAT(LASTDATE('Table'[Date]),"MM/DD/YYYY")
_Title =
VAR weenkenddate = [_Title test]
RETURN
    "Dashboard" & "as of(" & weenkenddate & ")"

Can you share your sample file for testing?

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.