Show Row Based on a Start Date and End Date

[lync0056]

Hi All,

Hopefully simple one... I have 2 Tables -

A Project Table which holds 2x columns - A Start Date and an End Date

A generic Date Table

Currently the model has a relationship between End Date and the Date Table.

I have a Date table filter on the page of November 2019.

1 Row from the Project Table has a start date of 1 September 2019 and end date of 31 December 2019.

Therefore because of the relationship with End date, it does not show. I need it to show because the month of November falls between the Start and End date.

Help please.

Cameron

[Anonymous · Accepted solution]

remove relationship between two tables.

USe your generic table in slicers whatever it is after slicer before slicer or between slicer.

Create one measure.

Filter= IF(Min(project[StartDate])<=min(Calendar[Date]) && Min(project[CloseDate])>=min(Calendar[Date]),1,-1 )

Add this measure in visual level filter and set it to 1.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.