Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Counting subtraction I expect to get 2000. So how write DAX formula in order to get this result? We have same object, it's id but different date with value, credit and debet. So if date is bigger than cre-det.
I have tried this
Solved! Go to Solution.
Hi, @Analitika
Try to modify @Anonymous 's formula as below:
Result =
VAR Credit =
CALCULATE ( SUM ( 'Table'[CRE] ), ALLEXCEPT ( 'Table', 'Table'[OBJ_ID] ) )
VAR Debit =
CALCULATE ( SUM ( 'Table'[DET] ), ALLEXCEPT ( 'Table', 'Table'[OBJ_ID] ) )
RETURN
Credit - Debit
Best Regards,
Community Support Team _ Eason
@Analitika Straightforward way:
Measure=var Credit=SUM('your_table'[CRE])
var Debit=SUM('you_table'[DET])
return Credit-Debit
Is wrong because I have many different object with values it's sum all table values.
Hi, @Analitika
Try to modify @Anonymous 's formula as below:
Result =
VAR Credit =
CALCULATE ( SUM ( 'Table'[CRE] ), ALLEXCEPT ( 'Table', 'Table'[OBJ_ID] ) )
VAR Debit =
CALCULATE ( SUM ( 'Table'[DET] ), ALLEXCEPT ( 'Table', 'Table'[OBJ_ID] ) )
RETURN
Credit - Debit
Best Regards,
Community Support Team _ Eason