Creating a new measure

[kimayasaraf]

This is my data and I'm trying to fetch the day from this date like Monday, Tue, etc. So far I have tried this formula 

OrderDay = FORMAT([Date], "dddd"). but it's not fetching the date column from the table and also tried writing the table name before [Date] but was unable to fetch that. 

[miTutorials · Accepted solution]

Try the below measure.

Month = FORMAT(SELECTEDVALUE('Calendar'[Date]),"DDDD")

[CoreyP]

Create a date table. In your date table, create a new column, "Day." Use that same formula you have.