topic Re: How can I show the number of rows that the due date value has been passed? in DAX Commands and Tips

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

BarryFletcher — Sun, 04 Feb 2024 11:28:47 GMT

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?

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

talespin — Sun, 04 Feb 2024 12:10:20 GMT

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.

use something like this

Count =

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

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

Anonymous — Tue, 06 Feb 2024 05:53:45 GMT

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

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

BarryFletcher — Tue, 06 Feb 2024 07:54:24 GMT

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

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

BarryFletcher — Tue, 06 Feb 2024 07:56:01 GMT

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

Can I set a table based on these results?

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

talespin — Tue, 06 Feb 2024 08:39:22 GMT

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.

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

BarryFletcher — Tue, 06 Feb 2024 08:41:27 GMT

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