Forum Discussion
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
Community 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.
- LeaRupnik
Helper III
Hello,
I am attaching an example, the result is correct at the third level and not at the higher levels.
https://drive.google.com/file/d/1Jy0l-WGouAHszo3eCFNzERGOwIM9_p37/view?usp=sharingthx Lea
- Icey
Community Support