Here is the problem I am facing. I have a table with dates and multiple transactions per day. I need to create a report where the user can select a specific date and a period (either MTD ither YTD).
Based on these two parameters, I should filter all the dates included in this time period. For instance, if the user selects 15/04/2020 and MTD, it should filter and keep all the values between 01/04/2020 and 15/04/2020 in all the visuals of the report.
How can I do this filter based on these user-selected parameters ?
Thanks a lot for your help ! I hope the definition of the problem is clear.