Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conversion Rate over Milestones

Hello all!   I want to create a measure to get the conversion rate of my projectos.   For that, I have a table with my projects: ID Project Name Net Sales 1 Project1 20 2 Project2 ...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Try this calculated column formula

=if(Data[Project ID]=1,if(CALCULATE(SUM(Data[%]),FILTER(Data,Data[Project ID]=EARLIER(Data[Project ID])&&(Data[Milestone Name]="Milestone1"||Data[Milestone Name]="Milestone2")))=2,"Complete","Incomplete"),if(CALCULATE(SUM(Data[%]),FILTER(Data,Data[Project ID]=EARLIER(Data[Project ID])&&Data[Milestone Name]="Milestone1"))=1,"Complete","Incomplete"))

Hope this helps.