Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

Important help in Creating DAX measure

Hi,

 

I have 3 formulas in excel, which i need to convert to DAX new measure in POWER BI, I tried doing myself but wasn't sucessful.

Can someone please help me out for the below 3 forumulas?

 

Datasetup is my table and the fields which you see in the formulas are  coloumns of Datasetup table

 

RevPlan_Growth =IF(TER_PFY_Constant= 0,0,(RevenuePlanFY_Constant-TER_PFY_Constant)/TER_PFY_Constant)

 

RevPlan_Achieved =IF(RevenuePlanFY_Constant=0,0,TER_FYTD_Constant/RevenuePlanFY_Constant)


GTER_Growth =IF(TER_PFYTD_Constant= 0,0,(TER_FYTD_Constant-TER_PFYTD_Constant)/TER_PFYTD_Constant)

Need Help
Show and Tell

2 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Hi vjnvinod,

    Please find below the requested 3 DAX Formulae. The Below DAX should be create as Calculated Columns

     

    RevPlan_Growth = IF(Datasetup[TER_PFY_Constant]=0,0,(Datasetup[RevenuePlanFY_Constant]-Datasetup[TER_PFY_Constant])/Datasetup[TER_PFY_Constant])
    RevPlan_Achieved = IF(Datasetup[RevenuePlanFY_Constant]=0,0,Datasetup[TER_FYTD_Constant]/Datasetup[RevenuePlanFY_Constant])
    GTER_Growth = IF(Datasetup[TER_PFYTD_Constant]= 0,0,(Datasetup[TER_FYTD_Constant]-Datasetup[TER_PFYTD_Constant])/Datasetup[TER_PFYTD_Constant])

    For your reference, using Imaginative Data, my Table after implementation of above columns, my result looks like as below

     

    Note: The 3 Calculated Columns are set as % values in Power BI to show them as percentages in the table

     

    If this solves your need, accept the solution and appreciate with a kudos!!!

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      8 years ago

      Thejeswar

       

      Superhelpful, thanks so much.

      But i think calculated coloumns will probably not work in my case, because let go with the below table with ID A, B, C.

      i have several lines within A , B & C, as a result this calculated coloumn is giving me inflated growth%

       

      do we have to create measure?