Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Overdebt receivables for particular date

Hello,   I'm struggling with this question for several weeks. Maybe someone has done that and will have some tips for me. I want to calculate how many overdue receivables was on a particular date....
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

Create a calculate column [PastDue Column] in table 'Custom legder Entry' instead if measure. Then in table 'Calendar', modify the measure [OverDue Receivable] using DAX as below:

OverDue Receivable = SUMX(
FILTER(ALL('Customer Ledger Entry'), [PastDue Column]>0),[Receivable, EUR])

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks, v-yuta-msft for your support, but it's not quite what I needed.

     

    I need to calculate overdue receivable for particular documents and month.

    • Firstly to filter all documents till MAX calendar date
    • Calculate PastDue date from Due date till max Calendar date
    • SUM all receivable where PastDue is more than 0.

     

    And it should be document row dynamic calculations.