Forum Discussion
Solved
Filter a table with dynamic dates
Hi everyone, I have two tables : 1. Classic Calendar table (date) 2. Project table (Project_code, Signature_date, Admin_launch_date, ...) I want to create a report where I can : 1. Know h...
Hi SMaz ,
Based on the description, you can change the calendar date range in the slicer visual to filter the table data.
Try using the following DAX formula to create a new measure.
Measure = var _date = SELECTEDVALUE('Project Table'[Signature_date]) RETURN IF(_date >= MIN('Table'[Date]) && _date <= MAX('Table'[Date]), 1, 0)Then, set the show item is 1 in Filters pane.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SMaz ,
Based on the description, you can change the calendar date range in the slicer visual to filter the table data.
Try using the following DAX formula to create a new measure.
Measure =
var _date = SELECTEDVALUE('Project Table'[Signature_date])
RETURN
IF(_date >= MIN('Table'[Date]) && _date <= MAX('Table'[Date]), 1, 0)Then, set the show item is 1 in Filters pane.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.