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..).
Go to Solution.
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.
View solution in original post
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Hope this helps.
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!