Filter results from due-date table

[Larsc]

Hi

We have a table that contains info on all invoices sent to customers. This table contains a due-date column.

I would like to make a visual that only takes values where the due date is reached.

That would give us information about what invoices have not been paid in time.

Customer	Amount	Posting Date	Open	Due Date
A	100	12/1-2022	1	12/31-2022
B	80	11/28-2022	1	31/11-2022
C	250	11/13-2022	0	12/25-2022

Table example

An open invoice has not yet been paid. I would like to have a visual that only shows unpaid invoices where the due date is in the past if that makes sense?

[v-zhangti · Accepted solution]

Hi, @Larsc 

You can try the following methods.

Measure = 
IF(SELECTEDVALUE('Table'[Due Date])<=TODAY()&&SELECTEDVALUE('Table'[Open])=1,1,0)

Put measure in the filters of the view you want to display and set it equal to 1.

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Larsc]

Hi @v-zhangti 

Thx for that, it works a bit more smooth then my own solution.

[Larsc]

For anyone stumbling upon this thread. I manage to solve the issue using the following measure

Measure = IF ( NOW() > FIRSTNONBLANK( 'Table'[Due Date], 'Table'[Due Date]), "True", "false")