Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago
Solved

Processing time

Hi all,   Can we create measure to calculate processing time per monthly based on some specific date on that transaction. Understand this is very very not clear.   For example I have this data : ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi  admin_xlsior ,

     

    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

     

    Best regards

    Amy Cai

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi admin_xlsior ,

 

You can create calendar table DateKey ,then create measure Process time(in days) to get process time up to end of month, and create measure No of WIP to count order id which is overdue.

 

DateKey= CALENDARAUTO()

 

Process time(in days) = DATEDIFF(Table1[Created date],EOMONTH(Table1[Created date],0),DAY)

 

No of WIP = CALCULATE(COUNT(Table1[Order Id]),FILTER(ALLSELECTED(Table1),EOMONTH(Table1[Created date],0)<Table1[Complete date]&&(Table1[Created date]<=MAX('DateKey'[Date])&&Table1[Complete date]>=MIN('DateKey'[Date]))))

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ER_nvIyBY7ZPkiCCPwVeh2MBq1jHFeNKiowhnFenYYPf7g?e=pfZvHf

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.