Forum Discussion
Finding calculation between two dates
I have Two rows that have One Assignee and a One Reviewer,
Assignee - Create Date & Complete date
Reviewer - Create Date & Complete date
| ECN | CT | Name | Create | Complete | Role |
| CN-XXXX1 | XXXXX | ID Parts | 1/01/2018 | 1/03/2018 | Assignee |
| CN-XXXX1 | XXXXX | ID Parts | 1/03/2018 | 1/10/2018 | Reviewer |
I would like to calculate/sum between "Assignee" Create Date and "Reviewer" Complete Date
8 Replies
OUWL - Are you looking for this in a measure or a column. Should the value show up for both or just for one? Trying to understand the use case but generally you are going to need EARLIER. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
my task is to find the avg. # of Parts Processed Per/Week using 12 months / 3 months
using a measure. the issue I am having is the Material Master (Excel) is calculated from Assignee start date to Reviewer Complete date so I only need that calculation seen below.
=IFERROR((SUMIFS(Table1[Old PN Count],Table1[MM Complete Date],">"
&TODAY()-365)/SUMIFS(Table1[Material Master],Table1[MM Complete Date],">"
&TODAY()-365))*5,"-")=IFERROR((SUMIFS(Table1[Old PN Count],Table1[MM Complete Date],">"
&TODAY()-90)/SUMIFS(Table1[Material Master],Table1[MM Complete Date],">"
&TODAY()-90))*5,"-")Regards
Hi OUWL ,
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
