Forum Discussion
Average Volumes by Date
I have a column called 'Logged Date' which takes the format of 31/08/2018 23:57:14
I want to build a bar graph to show the average volume of enteries by day (Monday, Tuesday, Wednesday etc..).
Hi Anonymous,
I made one sample for your reference.
1. Enter the sample data and create a calculated column.
weekday = FORMAT(Table1[Time],"ddd")
2. Create a measure as below.
Measure = CALCULATE(SUM(Table1[sales]))/COUNTROWS(Table1)
For more details, please check the pbix as attached.
Regards,
Frank
3 Replies
- Ashish_Mathur
Super User
Hi,
Try this
- Create a calculated column formula to extract the Data from the Date/time stamp Date=INT(Data[Logged Date]). Format this column as Date
- Create a Calendar Table
- Create a relationship from the Date column of the Base data table to the Date column of the Calendar Table
- In the Calendar Table, write thi calculated column formula to extract the Day of the week DoW=FORMAT(Calendar[Date],"dddd")
- IN yoru visual drag DoW from the Calendar Table
- Write this measure
=COUNTROWS(Data)
Hope this helps.
v-frfei-msftCommunity Support
Hi Anonymous,
I made one sample for your reference.
1. Enter the sample data and create a calculated column.
weekday = FORMAT(Table1[Time],"ddd")
2. Create a measure as below.
Measure = CALCULATE(SUM(Table1[sales]))/COUNTROWS(Table1)
For more details, please check the pbix as attached.
Regards,
Frank
- v-frfei-msft
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
