Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |