Forum Discussion
lcasey
Post Prodigy
Post ProdigyUse a calendar table for Invoices and Payments
Hello, I cant beleive I have not found a solution on the web for this extreemly common request. I am hoping someone in here may have a solution. I have 3 tables. A calendar table an Invoice ...
lcaseyPost Prodigy
Post ProdigyI think I found a measure that may work:
Balance Due = CALCULATE (
[Balance],
FILTER (
ALL ( '00-Bad Debt - Payments'[DATE1]), MAX ( '00-Bad Debt - Invoices'[DOCDATE] )
)
)
****Note*****
The "Balance" Measure used in the calculate is a simple formula of the difference between all invoices and all payments.
Balance = SUM('00-Bad Debt - Invoices'[SLSAMNT]) - Sum('00-Bad Debt - Payments'[APPTOAMT])
lcaseyPost Prodigy
Post ProdigyThat didnt work