Forum Discussion

kimayasaraf's avatar
kimayasaraf
New Member
2 years ago
Solved

Creating a new measure

 

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. 

Need Help
  • miTutorials's avatar
    miTutorials
    2 years ago

    Try the below measure.

     

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

2 Replies

  • miTutorials's avatar
    miTutorials
    Icon for Super User rankSuper User
    2 years ago

    Try the below measure.

     

    Month = FORMAT(SELECTEDVALUE('Calendar'[Date]),"DDDD")
  • CoreyP's avatar
    CoreyP
    Icon for Solution Sage rankSolution Sage
    2 years ago

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