Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sort by Day of Week

Hello,   I have a column that list a range of dates from 2013 - present. I was asked to analyze the data by each day of the week, for example, Monday would display specific information that occured...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Suppose your data table that lists a range of dates from 2013 to today is called "Table". Then, new a calculated column and type into this DAX formula: WeekDay = WEEKDAY(Table[Date],2)

     

    The numer "2" determine the start weekday is Monday in a week. To help you understand the WEEKDAY function, please see: https://docs.microsoft.com/en-us/dax/weekday-function-dax

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-yulgu-msftThank you! WeekDay = WEEKDAY(Table[Date],2), Do I enter this as is? It seems to be having a problem with "TABLE". I am brand new to DAX. What is table refering to? Is the "2" refering to the number of a day of the week, "Tues = 2, Wed = 3 etc."?

 

Thank you and sorry for the beginner questions.

 

kyle

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Suppose your data table that lists a range of dates from 2013 to today is called "Table". Then, new a calculated column and type into this DAX formula: WeekDay = WEEKDAY(Table[Date],2)

 

The numer "2" determine the start weekday is Monday in a week. To help you understand the WEEKDAY function, please see: https://docs.microsoft.com/en-us/dax/weekday-function-dax

 

Best regards,

Yuliana Gu