Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Receivable Balance Measure

Hello - Having trouble with arriving at the Receivable Balance calculation Measure. Goal is to provide the Balance of Customer as of a particular Historical date .  I tried using the measure to cal...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous ,

     

    You can simply your calculation but using the related calendar table instead of the facts table in your measure so for balance, that would be

    CALCULATE (
        SUM ( InvTable[Value] ) + SUM ( RcptTable[Value] ),
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
    )

    What I don't get is your current month number for CUS1. Per data, that should be 2000 and not 2100 (3500-1500).

    Please see attached pbix for details.

     

     

danextian's avatar
danextian
Super User
2 years ago

Hi Anonymous ,

 

You can simply your calculation but using the related calendar table instead of the facts table in your measure so for balance, that would be

CALCULATE (
        SUM ( InvTable[Value] ) + SUM ( RcptTable[Value] ),
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
    )

What I don't get is your current month number for CUS1. Per data, that should be 2000 and not 2100 (3500-1500).

Please see attached pbix for details.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

     

    Thanks danextian .You are right. It is 2000. Good solution.