Sum Average of five years given month and day

[Anonymous]

Hello Everyone!

I'm working on trying to take a dataset that needs to show the five year average of one value but only between June 10th and July 31st. 

I would like to have a slicer filter that allows the user to select the month and day instead of the month, day, and year between two values. The end result is to show the average sum breakdown of 2013 - 2017 compared to the 2019 sum. 

[Anonymous]

What you can do is parse your date column to split up the day, month, and year. Then you can make a slicer just for months and set a visual level filter for the years. 

[Anonymous · Accepted solution]

I solvedmy issue by creating a new column "ddmm" and filtered out the first 9 days of July out of the data set.  

[Anonymous]

This is the closest example I have to what I want it to look like, but the day range becomes misconstrued due to the fact that it won't include July 1 - 9 in this example. I need to see the data from June 10th - July 31st. Is there a way to merge the month slicer with the day range slicer and keep the year slicer separate? all my dates are separated into month, day, and year.  

[amitchandak]

This one should help you in creating a slicer. Also, you should able to create more formula's to get the Avg between certain ranges 

https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613