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())
SzymonKl's avatar
SzymonKl
Helper I
3 years ago

Thanks for solution unfortunetlly i getting the error :

 

johnyip's avatar
johnyip
Solution Sage
3 years ago

Sorry for the typo: it is MAX(

Day Name(MEASURE) = FORMAT(MAX('ORDERS'[ORDER_DATE]), "dddd")

 

  • SzymonKl's avatar
    SzymonKl
    Helper I
    3 years ago

    Thanks 

    I see the day name but unfortunately, instead of two records, I get much more. It seems that now the order has been assigned to each Wash Site. Wash Sites are stored in the 'WASH_SITES' table, column [NAME].

    Without measure : 

     

    with measure:

     

    • johnyip's avatar
      johnyip
      Solution Sage
      3 years ago

      Please provide some sample fake data that follows the data structure of your actual data, and the relationship between them for checking.

      • SzymonKl's avatar
        SzymonKl
        Helper I
        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())