Forum Discussion

Helper I

5 years ago

Table not showing summarized values

Hi, i am quite new to Power BI, but i am trying to make some with data ive successfully exported from our ERP system. I am now trying to have two collumns that one that summarize the positive numb...

Need Help

Syndicate_Admin

Administrator

4 years ago

After hours on google i have now tried the following formula with no success.

FORMULA = 
VAR _UTTAK = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[ACCOUNT]="2901")
VAR _UT = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[POSTINGTYPE]<>122)
VAR _INN = SUMX(PROJINVOICEJOUR,PROJINVOICEJOUR[FAKTURERT])

return IF(_INN-_UT-_UTTAK<0,_INN-_UT-_UTTAK,0)