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, September 29 at 11a PDT for a great session with Ted Pattison!