Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Excel Formula into DAX Formula

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

DAX
DAX ALL PowerBI Excel
DAX Calculation
dax calculations

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      A better way to write the formula would be 

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