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.
Hi, Please can you help. I need to produce the result in 'Report' from the data on the left
OrderDate | ClosedDate | ||||
20/11/2020 | 20/11/2020 | Report | |||
20/11/2020 | 23/11/2020 | Date | Outstanding Orders | ||
20/11/2020 | 23/11/2020 | 20/11/2020 | 4 | (5 orders - 1 closed) | |
20/11/2020 | 22/11/2020 | 21/11/2020 | 8 | (5 orders + 4 outstanding on 20/11 - 1 closed) | |
20/11/2020 | 27/11/2020 | 22/11/2020 | 14 | (7 orders + 8 outstanding from 21/11 - 3 closed + 2 Not complete) | |
21/11/2020 | 23/11/2020 | ||||
21/11/2020 | 24/11/2020 | ||||
21/11/2020 | 29/11/2020 | Blank = Not Complete | |||
21/11/2020 | 21/11/2020 | ||||
21/11/2020 | 28/11/2020 | ||||
22/11/2020 | |||||
22/11/2020 | |||||
22/11/2020 | 22/11/2020 | ||||
22/11/2020 | 24/11/2020 | ||||
22/11/2020 | 28/11/2020 | ||||
22/11/2020 | 24/11/2020 | ||||
22/11/2020 | 22/11/2020 |
Solved! Go to Solution.
@arunmathew12345 , refer by blog hr, seem, similar current employee,
https://www.youtube.com/watch?v=e6Y-l_JtCq4
Thank you so much @amitchandak . I have 2 questions for you
1. How can I add a monthly average to this?
2. Do you offer 1:1 coaching on Pbi?
@arunmathew12345 , refer by blog hr, seem, similar current employee,
https://www.youtube.com/watch?v=e6Y-l_JtCq4
Hi Amit,
Is there a way to find average of current employee column in your table between given set of dates?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |