Forum Discussion
Mous007
Helper IV
Helper IVNext items to be overdue measure or column
Hello everyone, I have a column to calculate the overdue dates as follow: overdue days = TODAY() - ' Report 01_2020'[ActionDueDate] i the created another column for the overdue buckets; ...
Your current calculations are fine, and you can do the same for due soon items.
Also, you might consider making a top x of the negative values to show the next x amount of items going due the soonest.
This can just be done with the Top N in the filters pane 🙂
Your current calculations are fine, and you can do the same for due soon items.
Also, you might consider making a top x of the negative values to show the next x amount of items going due the soonest.
This can just be done with the Top N in the filters pane 🙂
Mous007Helper IV
Helper IVthank you all for your propositions.
I have used the Top N option as it was the easiest for me to implement.
Many thanks again