Calculated measure to show a late issue by date

Questions & Answers
1

I am trying to show how late an issue is based on the Issue Due date field. My formula for the calculated measure is: [Measures].[Issue due] < Now()

I’ve tried multiple versions to clear the error without success.

2

Hi @brianpatrickjackson

To compare two dates in eazyBI, you may want to use function DateCompare(): https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datecompare

Though, for overdue issues, there is a demo report where you can find and copy a calculation formula for Overdue issues : https://eazybi.com/accounts/1000/cubes/Issues/reports/249876-issues-due-and-overdue

Best,
Ilze / support@eazybi.com