Date Filters/Functions in DAX

[carolynhn25]

Hello!

I am trying to use two date columns from the same table to filter a page in my report but am having difficulty getting the end results that I want. There are two components to what I'm trying to do.

1. I need to filter the data in the table to only return results inbetween the dates in two columns

2. I want the report page to default to today's date, with the option of changing the date with a slicer

So the end result I'm aiming for is for the data to be filtered to only include rows with a date inbetween the two columns, and then the report page auto-filtered for TODAY with the option of adjusting the dates via slicer. 

Thank you in advance for any help you're able to provide!!

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Value measure: =
CALCULATE (
    SUM ( Data[Value] ),
    FILTER (
        Data,
        Data[DateStart] <= MAX ( 'Calendar'[Date] )
            && Data[DateEnd] >= MIN ( 'Calendar'[Date] )
    )
)