topic Re: Aged Debt Date Wont populate in a Report in DAX Commands and Tips

Aged Debt Date Wont populate in a Report

Sean-OReilly — Thu, 23 Jul 2020 09:47:56 GMT

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

Re: Aged Debt Date Wont populate in a Report

nvprasad — Thu, 23 Jul 2020 17:00:14 GMT

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

Re: Aged Debt Date Wont populate in a Report

Sean-OReilly — Thu, 23 Jul 2020 20:57:22 GMT

thanks for your response.

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

Re: Aged Debt Date Wont populate in a Report

Anonymous — Fri, 24 Jul 2020 06:43:36 GMT

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 () )

Re: Aged Debt Date Wont populate in a Report

Sean-OReilly — Tue, 28 Jul 2020 20:14:41 GMT

Thanks a million Harshnathani