cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martin900 Regular Visitor
Regular Visitor

find records in between dates

Hi

 

I have two fields

From date

To date

 

I want to have a variable in my report so i can type in example year 2015 and the result will find all records where 2015 is between or on "from date" and "to date".

 

Thanks for help!

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: find records in between dates

There are a couple solutions to this issue.

 

You can go more of a dynamic route and allow the utilizations of both a YEAR and a DATE slicer. Allow users to set a year using radio buttons, then allow them to enter a date range using a date slicer. I would reccomend using a calendar table too if you're not.

 

You also can create static variable within measurs that could contains your Min and Max Dates for any calculation.

 

Let me know if you're interested in either, and would like some more infomation.

 

 

View solution in original post

4 REPLIES 4

Re: find records in between dates

There are a couple solutions to this issue.

 

You can go more of a dynamic route and allow the utilizations of both a YEAR and a DATE slicer. Allow users to set a year using radio buttons, then allow them to enter a date range using a date slicer. I would reccomend using a calendar table too if you're not.

 

You also can create static variable within measurs that could contains your Min and Max Dates for any calculation.

 

Let me know if you're interested in either, and would like some more infomation.

 

 

View solution in original post

martin900 Regular Visitor
Regular Visitor

Re: find records in between dates

hi

 

Thanks for your time and answer.

 

The issue is that the date ranges are not fixed (to and from date), so i cant use a slicer on to date and from date.

 

Examle:

I want all records in 2015

here to-date can be on 2015 or later and from date can be on 2015 or before

 

Please share more information 🙂

 

Thanks

Highlighted

Re: find records in between dates

To clarify -

 

You want to be displayed either "To Date" or "From Date", that contains 2015?

 

Sharing some examples of your data will be helpful.

martin900 Regular Visitor
Regular Visitor

Re: find records in between dates

Thanks. The answer was in your first post 🙂

 

I created to date filters. so to find all records for 2017 it will be: from date = 2017 and before and 2017 and beyond in the second

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors