Forum Discussion

LeaRupnik's avatar
LeaRupnik
Icon for Helper III rankHelper III
5 years ago

IBM cognos fromula to PowerBI

Hello

we have an IBM Cognos now we everything copy to AST and PowerBI. 

I have a formula in Cognos like this: 

['REAL NAB KOL']=
N: STET;
C: IF(DTYPE('CPP_CAS_POSNETKA',!CPP_CAS_POSNETKA) @='N', STET,
DB('CPP',
ELCOMP('CPP_CAS_POSNETKA',!CPP_CAS_POSNETKA,ELCOMPN('CPP_CAS_POSNETKA',!CPP_CAS_POSNETKA)),
!CPP_ZA_MESEC,
!CPP_FIRMA,
!CPP_MERA
)
)
;

['REAL NAB PREMIJA']=C:['REAL NAB PREMIJA VRED'] \ ['REAL NAB KOL'] * 1000;

['REAL NAB PREMIJA VRED']=
N:['REAL NAB PREMIJA'] * ['REAL NAB KOL'] \ 1000;
C: IF(DTYPE('CPP_CAS_POSNETKA',!CPP_CAS_POSNETKA) @='N', STET,
DB('CPP',
ELCOMP('CPP_CAS_POSNETKA',!CPP_CAS_POSNETKA,ELCOMPN('CPP_CAS_POSNETKA',!CPP_CAS_POSNETKA)),
!CPP_ZA_MESEC,
!CPP_FIRMA,
!CPP_MERA
)
)
;

 

How to do this in dax formula. 

 

THX. 

LEa

8 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi LeaRupnik ,

     

    Sorry, I know little about IBM Cognos.

    Could you provide a concrete example to show me the calculation logic? Then I could create DAX formulas directly.

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.