Is this date between Start & End Date? with PowerBI

[akiss4u]

Okay, first of all, I am new at this whole PowerBI thing.

Been struggling with references and searches for few weeks to solve this.

I got some data with Start and End date in them.

And I have Calendar table basically dates.

I want to filter Prgram No. with the calendar date, if the date is in the start and end date range.

For example, if date '01/02/2016' is selected I want program no.(s) with (Start Date <= '01/02/2016' and End Date >= '01/02/2016')

Currently I can only filter by Start Date = '01/02/2016' or End Date = '01/02/2016'.

Please Help!!!

Schedule DataFiltered by date in durationThank You all

[SqlJason]

Normally, you wouldn't filter one dimension with another dimension. What I mean by that is, you wouldn't expect to see all the countries (Geography dimension) for January (Date dimension). However, you can filter it once you bring the context of a fact/measure. For eg, you can filter all the countries that had Sales (measure) for January.

That said, if you had a measure (maybe like number of hours), I can suggest the method to filter all the projects where the selected dates are between the start dates and end date. The pattern here is to create a disconnected Date table (a table with the list of dates, which has no relationship to the fact table) and then create a measure which will display value only for projects where the dates are between start and end dates. That pattern is also explained in the blog below.

http://www.powerpivotblog.nl/get-values-within-a-start-and-end-date-using-powerpivot-dax/

[Anonymous]

Hi @akiss4u,

   when you say "..if date '01/02/2016' is selected.." you mean that you created a slicer visual based on StartDate or EndDate to select the date?

#I'M Not An Expert#

[fbrossard]

Hi @akiss4u,

You can simply define filter (for a report, a page or a visual), drag n drop your date attribute into the filter area, click on advance filter and select your range

If you wanna do this by a vsual like a Excel timeline slicer, try playing with the "timeline" custom visual see https://app.powerbi.com/visuals/