Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter issue - Date aggregation

Hello guys,    I'm facing an interesting problem.     Basically, I created some measures to calculate if a Purchase order (PO) has been received on time or not. To do this, the measure ( datediff...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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, 

Icey's avatar
Icey
Community Support
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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, 

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    I have no access to click "I agree". Please use other tools, such as OneDrive for Business. Thank you!

     

     

    Best Regards,

    Icey