Forum Discussion
Filtering two dates from one date selection in slicer
I have a problem where I need to show results for the current date selection as well as the December before the current date when selecting a date in a filter.
For example:
Select:
April 2017
Result:
April 2017
December 2016
Or
Select:
October 2016
Result:
October 2016
December 2015
Is arranging such a table possible within Power BI?
Thanks Phil_Seamark.
I found an acceptable solution which I was able to modify from a previous discussion here:
-Aman
2 Replies
- Phil_Seamark
Microsoft Employee
Hi Anonymous
Yes this is possible by writing your DAX calculations to go find the december data. Nornally these are usually written to find a previous period such as the previous month, but can easily be tweaked to meet your requirement.
If you share a small sample of your data, we can suggest a calculation.
Phil
Thanks Phil_Seamark.
I found an acceptable solution which I was able to modify from a previous discussion here:
-Aman
