cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

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 just on every monday and the same for tuesday, etc.

People have been pointing me to

`WeekDay = WEEKDAY(Table[Date],2)`

But it is not working. We are attempting to analyze the amount of tickets we recieve per day of the week and would like vizualize our busiest days.

Thanks

1 ACCEPTED SOLUTION
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Employee

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.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@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

Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors