Forum Discussion
craigdent
5 years agoFrequent Visitor
Help with dates between two rows
Hi all, I have a table with payroll cut off dates and would like to filter another table based on results between each cut off date. I'm not sure where to start, I've thought about creating colum...
v-lili6-msft
5 years agoCommunity Support
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
craigdent
5 years agoFrequent Visitor
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.
- v-lili6-msft5 years agoCommunity Support
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