Forum Discussion

SzymonKl's avatar
SzymonKl
Helper I
3 years ago
Solved

Day Name in DirectQuery

Could you kindly assist me in creating a measure to display the day name based on the 'ORDERS' table and the [ORDER_DATE] column? It's important to consider that we are working with DirectQuery, and ...
Need Help
  • SzymonKl's avatar
    SzymonKl
    3 years ago

    Hi Thanks for your support today 🙂 

    I was able to find the right solution, instead measure I create a new column : 

    Day Name = SWITCH(WEEKDAY('ORDERS'[ORDER_DATE]),
                    1, "Sunday",
                    2, "Monday",
                    3, "Tuesday",
                    4, "Wednesday",
                    5, "Thursday",
                    6, "Friday",
                    7, "Saturday",
                    BLANK())
mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi SzymonKl 

 

Are you using a calendar table? Maybe you can compute the day name there and get it by using the relation?

SzymonKl's avatar
SzymonKl
Helper I
3 years ago

No , the [ORDER_DATE] column is in 'ORDERS' table and is a Date/Time format.