Forum Discussion
Solved
Filter results from due-date table
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...
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.
v-zhangti
Community Support
Community SupportHi, 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.
