Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Measure - AVERAGE NUMBER OF ORDERS PER WEEKDAYS

‎03-13-2020 02:20 AM

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!

 

Labels:
Message 1 of 5
1,172 Views
0
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support
In response to Anonymous

‎03-16-2020 01:29 AM

@Anonymous 

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Calculating-Working-Days-Left-in-Month-excluding-holidays/m-p/961149#M460524

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 5 of 5
1,123 Views
0
4 REPLIES 4
amitchandak
Super User
Super User

‎03-13-2020 02:26 AM

Can you share sample data and sample output.

 



Message 2 of 5
1,169 Views
0
Anonymous
Not applicable
In response to amitchandak

‎03-13-2020 03:14 AM

Screens with measures Measures.PNG

 

Message 4 of 5
1,155 Views
0
v-chuncz-msft
Community Support
Community Support
In response to Anonymous

‎03-16-2020 01:29 AM

@Anonymous 

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Calculating-Working-Days-Left-in-Month-excluding-holidays/m-p/961149#M460524

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 5 of 5
1,124 Views
0
Anonymous
Not applicable
In response to amitchandak

‎03-13-2020 02:50 AM

Hi,

Below screens from PowerBI 🙂

 

 

power BI - screen.PNG

 

 

 

Message 3 of 5
1,167 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All