Forum Discussion
royalty123
2 years agoRegular Visitor
Need Help with Project Types
Hi, I have two types of projects 1. Agile 2. Software. The below formulas apply to both the Project types. Initially our projects took 3 months to complete but lately it was taking 6 months so I want...
johnbasha33
2 years agoSuper User
royalty123 we can work it out with a dynamic calculation.
check and let us know if it works.
calculated column:
LeadTime =
IF ( Projects[ProjectType] = "Agile", 12, 3 )
use this in the visual.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!