Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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
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
@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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |