Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |