Using Datesbetween function without the years

[mikelee1701]

Hi,  

I am trying to use this:

Peak Period =

CALCULATETABLE(

'Date',

DATESBETWEEN('Date'[Date],DATE(2020,11,15),DATE(YEAR(2020,12,31))

)

However, the problem is that I'm limited to just 2020.

I am looking at multiple years but only within the dates of 11/15 to 12/31.

So basically all years(ie 2021,2020,2019,...) in between those dates.

Thanks in advance for any suggestions.

Mike

[parry2k · Accepted solution]

@mikelee1701 create a table for all the year and add a column to flag this date range and then use page-level or report level filter on the flag to filter other dates.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[mikelee1701]

Closing this out because while I didn't use this specific method, it gave me another idea... thank you.

[mikelee1701]

Thanks, but I don't think I will use the report filters.  I have a'dashboard' going on where I plan on having the user click on a single button where they can compare a peak period from one year to another year