Cumulativa withaut data table
Hello, I have an example with cumulative but the sum I would like a cumulative by year. Kumulativa_real_cpp:= var prava_vrednost = MAX('cisppr vw_CistaProdajnaPremija'[Za leto/mesec VR]) return CALCULATE([Real nab količina_f], ALLSELECTED('cisppr vw_CistaProdajnaPremija'), 'cisppr vw_CistaProdajnaPremija'[Za leto/mesec VR]<=prava_vrednost ) thx LeaIBM 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
