Need to get Date Format

[jay_patel]

Hello Friends, 

I am created a date table and converted into dd/mm/yyyy, 
but here the requirement is need to get dd/mm/yyyy (day name) i am tried and mentioned below images.
getting into mm/dd/yyyy (day name ) how to get as dd/mm/yyyy (day name).

Please help me. how to write dax. 

In matrix visual getting like this need to get dd/mm/yyyy (day name)

[v-yuaj-msft]

Hi @jay_patel ,

@selimovd 's and @amitchandak 's idea is great. I just modify your original DAX expression a little.

Date & Name=FORMAT('Date'[Date (bins) 2],"dd/mm/yyyy")&" "&"("&'Date'[DayName]&")"

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @jay_patel ,

you can add a calculated column and use the format function. The following format should bring you the result you want:

Date and Name = FORMAT ( [Date], "M/D/YYYY (dddd)" )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[amitchandak · Accepted solution]

@jay_patel ,

To format a date you can use

New Date = format([Date], "dd/mm/yyyy (dddd)")

For UK/India format of date, make sure your setting is correct

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...