Filter/Measure data between dates in slicer

Hi v-piga-msft,

Thanks for your reply.

There are 3 tables in total:

• Table: with the actual data (employee, from, to, amount)
• Year: just one column, with years   (2016, 2017, 2018)
• Month: just one column, with 12 months    (01,02,03...12)

I used the logic in HERE: 2 disconnected tables for the slicer and use a calculated measure as a filter for the visual.

Using the example in the original post. Let's say the user selects 2018 and 09. For September the rows selected should be:

                      From             To            Monthly Amount

Employee A   2018-01-01  2018-12-01  $500

Employee A   2018-01-01  2018-12-01  $200

Employee B   2018-09-01  2018-12-01  $800

For August, the previous month, should be:

                      From             To            Monthly Amount

Employee A   2018-01-01  2018-12-01  $500

Employee A   2018-01-01  2018-12-01  $200

Employee B   2018-01-01  2018-08-31  $1000

Employee C   2018-01-01  2018-08-31  $200

And what I need to do is: group the amounts by employee and show the selected month amounts in one column and the previous ones in another one:

                    SelectedMonth   PreviousMonth

Employee A          700                   700

Employee B          800                  1000

Employee C           0                      200

The problem I have is that I don't know how to manage different dates in each column, the SelectedMonth coming from a slicer.

Thank you,