Forum Discussion
Current period Filter should filter previous year Data
- 7 years ago
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
Thanks for your post.Unfortunatley both the blogs not helps for my scenarios.
I have around 5 tables like(table1,table2,table2,etc) and separately one period table I need the Date filter where user should select the date to see the data.
my problem is in period table it will only contain the current month start date and end date.So if i create relationship between 5 tables i couldn't see the previous months data because in period table it has only 1-Feb-2019 and 28-Feb-2019.
But I need the Date filter as like below.By default from and To date must show the current period
Even if i pick 2018 date Data should filter.
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373