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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.