Aged Debt Date Wont populate in a Report

[Sean-OReilly]

Hi

I have used a measure to calculate Aged Debt - please see the measure calculation below:

2 Sales Aged Date =

if([2 - Sales Invoice Date]<[1 - Today],

DATEDIFF([1 - Today],[2 - Sales Invoice Date], DAY),

blank())

When i insert this measure into a Table Visual the result will not display - a wheel keeps spinning in the top left of the visual... what am i doing wrong?

I want to create a measure that subtracts sales invoice date from todays date.

Thanks in advance for your help

[harshnathani · Accepted solution]

Hi @Sean-OReilly ,

See if this helps.

https://community.powerbi.com/t5/Desktop/Debt-Aging/m-p/1067551

https://community.powerbi.com/t5/Desktop/Dynamic-Accounts-Receivable-Aging/m-p/304192

Else try this as a measure

invoicedatedif =
IF (
    MAX ( working[InvoiceDate] )
        < TODAY (),
    DATEDIFF (
        TODAY (),
        MAX ( working[InvoiceDate] ),
        DAY
    ),
    BLANK ()
)

[Sean-OReilly]

Thanks a million Harshnathani 

[nvprasad]

Hi,

Please try the below function.

invoicedatedif =
IF (
CALCULATE ( MAX ( working[InvoiceDate] ) ) < TODAY (),
DATEDIFF ( TODAY (), CALCULATE ( MAX ( working[InvoiceDate] ) ), DAY ),
BLANK ()
)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[Sean-OReilly]

thanks for your response.

Unfortunately i am getting an error - see screenshot below... cant see where im going wrong?