Forum Discussion
Solved
Need help on Measure
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 |
arunmathew12345 , refer by blog hr, seem, similar current employee,
https://www.youtube.com/watch?v=e6Y-l_JtCq4
3 Replies
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?
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?
