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

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

Hi Anonymous,

 

After adding a calculated column WeekDay = WEEKDAY(Table[Date],2), you should place [WeekDay] column and [tickets amount] column into a table visual. Choose "Sum" as its aggregation function, it will automatically sum up the ticket amounts sorted by each weekday.

 

For more advice, please provide some dummy data and show your expected result. How to Get Your Question Answered Quickly

 

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