How to calculate days past due

Questions & Answers
1

I am trying to create a new calculated member which provides the number of days an issue is past its due date. I do not know what measure to use for the current/todays date. Here is where I am stuck.

DateDiffDays(
[Measures].[Issue due date],
Todays date
)

2

Hi @esadowsky,
You are almost there, the formula you are looking for is:

DateDiffDays(
[Measures].[Issue due date],
now()
)

best,
Gerda // support@eazyBI.com