Forum Discussion
Anonymous
6 years agoNot applicable
Measure - AVERAGE NUMBER OF ORDERS PER WEEKDAYS
Hi All,
I need your help with creating new measure Average Number of Orders per Weekdays.
I have created below columns in my table:
- Document Date: 2020-01-06
- Purchase Order YearMonth: 2020-1
- WeekdayName: Monday
- Weekday1: 1 (1 - Monday, 7 - Sunday)
I have created also below measures:
- Total number of Orders
- Number of Orders per Month
... but I still have a problem with creating measure Average Number of Orders per Weekdays...
Can you please help me with this measure?
Thank you in advance!
Anonymous
You may take a look at the post below.
4 Replies
- amitchandak
Super User
Can you share sample data and sample output.
- AnonymousNot applicable
Hi,
Below screens from PowerBI 🙂
- AnonymousNot applicable
Screens with measures
- v-chuncz-msft
Community Support
Anonymous
You may take a look at the post below.