How can I show the number of rows that the due date value has been passed?

[BarryFletcher]

Hi all,

I have a table with a "Due Date" columnd / value. How can I list all records that have passed this date and need to be listed as Overdue?

[Anonymous]

Hi @BarryFletcher ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[BarryFletcher]

Apologies for the deayed reply but I was away for 2 days.

In my table below the "Due Date" can be unique to each row. At the moment I have 279 rows with a Due Date set - what i would like to be able to report on is the rows which have exceeded their Due Date

[talespin · Accepted solution]

hi @BarryFletcher 

You could Put all records in a table or get count and apply filter at visual level where DueDate < Current date without explicit DAX.

or

use something like this

Count =

CALCULATE( COUNTROWS(TestTable2), REMOVEFILTERS(TestTable2), TestTable2[CreatedDate] < UTCTODAY())

[BarryFletcher]

Thank you - I have set this but changed the Due date <UTCTODAY()

Can I set a table based on these results?

[talespin]

hi @BarryFletcher ,

Can I set a table based on these results?

Sorry didn't understand. Please explain.

If you can share screenshot what you have and what you expect, that would help.

[BarryFletcher]

It's ok I have a table setup now with a page filter applied as you suggested earlier.