Excel Formula into DAX Formula

[Anonymous]

Hi All, 

I am trying to set up a formula in DAX but not sure where to start. I have this on excel but need to translate this to DAX format for powerbi.

So a bit of background. I am trying to understand the percentage completion for a current project. For example the team have to go from 6000 (baeline) to 1150 (Target) for them to completed the acitvity. Therefore when the team hit 1150 they wouldve completed 100%. So i did an interpolation formula on excel as i wasnt sure how to do this on DAX. 

The formula is (-100(Current No - Target No)/(Baseline-Target No))+100. 

Can someone help me.

RU

[Aditya_Meshram]

Hi @Anonymous ,
you can make a new measure with the following DAX

Completion % = -100 * DIVIDE(Current No - Target No,Baseline-Target No,0) + 100

Regards,

Aditya

[Aditya_Meshram]

A better way to write the formula would be 

Completion % = 100(1- DIVIDE(Current No - Target No,Baseline-Target No,0))

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.