Forum Discussion
Help with dates between two rows
@craigdent
I did not take any dates table into my formula. You wanted to filter the table that you showed in the question based on the logic you mentioned. These formulas can be used to filter other tables. Why do not share a sample PBIX file with some sample data to check? Also, mention the expected result.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
My .pbix can be found here: Overtime Report - wasn't sure how to attached a file as I kept getting an error saying the file type is not supported!
Ideally, what I'd like is a dropdown slicer at the top with the Month from the Overtime Deadlines table which the filters the table based on the ApprovedDatestamp - the ApprovedDatestamp must be before the Date that the Month relates to, but after the previous Date above it.
hi craigdent
I'm a little confused by your description, what is your expected output in this sample pbix file.
Can you give me an example based the data.
Regards,
Lin
Hi Lin,
What I'm looking for is a slicer visual which can select from the Date field in the Overtime Deadlines table, which will then filter the main Table visual for those records with an ApprovedDatestamp before the selected date, but on or after the previous Date.
hi craigdent
Could you show us the expected output with an example in your sample pbix file, that will be a great help.
Regards,
Lin
