Filtering two dates from one date selection in slicer

[Anonymous]

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?

[Phil_Seamark]

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

[Anonymous · Accepted solution]

Thanks @Phil_Seamark.

I found an acceptable solution which I was able to modify from a previous discussion here:

https://community.powerbi.com/t5/Community-Knowledge-Base/Rolling-N-Dates-based-on-slicer-selection/...

-Aman