Forum Discussion
Filter issue - Date aggregation
Hi Icey ,
Thank you, please find the file attached and the results in PO on time 3 and PO delayed 3.
Let me know if you have any suggestion to improve it,
Regards,
Hello Icey ,
Thank you for your very detailed explaination which helped a lot to understand the logic.
Nevertheless, the solution proposed doesn't fit because both of the POs should be delayed and with the solution there is only one.
Finally I created a summarize table to group by the Purchase order by date diff and use this date to make the calculcation and as you can see below, now both of the Po are counted as delayed and zero on time :
Many thanks for your help,
Hi Anonymous ,
Glad to hear that you have solved the problem. Are you happy to share your solution based on the .pbix I uploaded before?
In addition, the expression of [PO delayed 2] in my previous reply needs to be modified like below. I have edited it in my previous reply.
PO delayed 2 = IF([PO delayed]=1,1)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey ,
Thank you, please find the file attached and the results in PO on time 3 and PO delayed 3.
Let me know if you have any suggestion to improve it,
Regards,
Hi Anonymous ,
I have no access to click "I agree". Please use other tools, such as OneDrive for Business. Thank you!
Best Regards,
Icey