cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Analitika
Post Prodigy
Post Prodigy

How count value according to these values of rows?

Analitika_0-1634046057770.png

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

Sukaupta_suma =
var _max = maxx(filter('x', [DATE] <[DATE]),[DATE])

var _val = sumx(filter('x',[DATE] =_max), [CRE]-[DET])

return
[CRE]-[DEB]
 
But this not helped because I am getting 8000
                                                                 -6000, as the result.
1 ACCEPTED SOLUTION

Hi, @Analitika 

Try to modify @Marik '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

 

159.png

 

Best Regards,
Community Support Team _ Eason

View solution in original post

3 REPLIES 3
Marik
Solution Supplier
Solution Supplier

@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 @Marik '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

 

159.png

 

Best Regards,
Community Support Team _ Eason

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.