I would like to give my users the ability to create and print a report of Timesheets based on user defined timeframe.
For Example: A user would be able to select a “Date From” Dec 1,2019 and Then a “Date To” Dec 31, 2019 and then a report would be generated showing all timesheets that are within the month of December. Then they would be able to print this report.
The last virtual column in the screenshot above is where I would like all items that are matching the criteria set by the user to be ( I just have a fake formula for the time being).
I was able to find a sample app that shows a basic principle of what I am trying to accomplish.
In the column Matching Items in the Report Request table there is this formula:
SELECT(Data[Name], AND(IN([Size], [_THISROW].[Size Choice]), IN([Color], [_THISROW].[Color Choice])))
However instead of it using colours and sizes I want it to show all matching items that are within the dates that the user would select.
Any help with accomplishing this would be greatly appreciated.