Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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!

 

4 Replies